*** silphium has joined #idempiere | 00:33 | |
*** silphium has quit IRC | 00:35 | |
Not-7634 | [iDempiereDaily] jenkins built #491 completed (success) http://ci.idempiere.org/job/iDempiereDaily/491/ | 02:46 |
---|---|---|
Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-3220 Attachment set to "None" | 03:25 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 03:25 |
Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-3220 Attachment set to "IDEMPIERE-3220.patch" | 03:25 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 03:25 |
Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-3220 | 03:43 |
Not-7634 | [IDEMPIERE] hi [~carlosruiz_globalqss] i update patch for other control Listbox is ok, because we use setDisabled and it become a textbox still two issue: 1. button control: have to remove onClick, onOk event 2. apply fix to other place, now just apply to weditor and extends of weditor example: at form sometime dev use weditor to make filed, but some time use direct zk component I will do it late. | 03:44 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 03:44 |
Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-3220 status set to "Peer Review Queue" | 03:45 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 03:45 |
*** nmicoud has joined #idempiere | 04:51 | |
Not-7634 | [iDempiere3.1Daily] jenkins built #95 completed (success) http://ci.idempiere.org/job/iDempiere3.1Daily/95/ | 05:21 |
*** CarlosRuiz has joined #idempiere | 07:38 | |
*** CarlosRuiz has quit IRC | 07:46 | |
*** posde has quit IRC | 08:33 | |
*** posde has joined #idempiere | 08:51 | |
Not-7634 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3220 | 09:20 |
Not-7634 | [IDEMPIERE] Thanks [~hieplq], tested this new patch: - checkbox (Sales Order > Self Service) java.lang.ClassCastException: org.adempiere.webui.component.Checkbox cannot be cast to org.zkoss.zul.impl.InputElement at org.adempiere.webui.util.RequestUtil.checkEditReadonlyComp(RequestUtil.java:67) at org.adempiere.webui.component.Checkbox.service(Checkbox.java:84) - textbox (Sales Order > DocumentNo) worked fine - list | 09:20 |
Not-7634 | (Sales Order > Document Type) the field was cleared and then user cannot save with error "FillMandatory - Document Type" - this could be a problem if the field is not mandatory, didn't test that case same with Document Status and Currency - date (Sales Order > Sales Order Line -> Date Ordered) worked fine - search (Sales Order > Sales Order Line -> Business Partner) worked fine - resource assignment (Sales Order > | 09:20 |
Not-7634 | Sales Order Line -> Resource Assignment) worked fine - ASI (Sales Order > Sales Order Line -> Attribute Set Instance) worked fine - datetime (Business Partner > Contact (User) > EMail Verify) worked fine for date and time boxes - date (Business Partner > Contact (User) > Last Contact) worked fine Regards, Carlos Ruiz | 09:20 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 09:20 |
*** CarlosRuiz has joined #idempiere | 09:20 | |
*** posde has quit IRC | 09:37 | |
Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-3220 Attachment set to "IDEMPIERE-3220_combobox.patch" | 10:22 |
Not-7634 | [IDEMPIERE] hi [~carlosruiz_globalqss] I add patch for your comment. | 10:22 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3220 | 10:22 |
*** hieplq has joined #idempiere | 10:53 | |
Not-7634 | [IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-3221 Add ability to report/group by Parent Product Category on Invoice Detail & Margin | 13:21 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3221 | 13:21 |
*** hieplq has quit IRC | 13:42 | |
*** hieplq has joined #idempiere | 13:58 | |
hieplq | anyone have experience to manage big table like AD_CHANGELOG and AD_ISSUE? | 14:01 |
CarlosRuiz | Hi hieplq - what do you need with that? | 14:18 |
hieplq | my table is so big (16G) so insert and update take long time | 14:19 |
hieplq | i think about create a temp table and insert to temp table first (more to real table at other thread, so don't let user wait) | 14:20 |
hieplq | or use partition, with partition maybe i have change more things (sql to get history change of record, insert, update command) | 14:22 |
hieplq | so i want to ask before decide | 14:22 |
CarlosRuiz | I usually delete AD_Issue periodically | 14:24 |
CarlosRuiz | AD_ChangeLog is a good source for auditing - but you could also take a backup of old records and preserve just recent | 14:25 |
CarlosRuiz | but, about your question - in DBs insert operations must not be affected by the size of a table - I think postgresql must do a good job on that | 14:27 |
hieplq | but my friend use oracle :( | 14:28 |
CarlosRuiz | update operations are affected by size of table in case the where clause doesn't get a good index - or if the table has not been ANALYZEd | 14:28 |
CarlosRuiz | yes - oracle must be even better for that | 14:28 |
CarlosRuiz | now | 14:28 |
CarlosRuiz | both, insert and update operations are affected by the number of indexes | 14:29 |
hieplq | oh. so i should try run maintain database | 14:29 |
CarlosRuiz | those two tables are not intended to be updated - so I think they must not be affected by slow updates | 14:31 |
hieplq | ah, they add two more index to AD_CHANGELOG | 14:31 |
hieplq | ah, it just affect when insert | 14:31 |
CarlosRuiz | maintaining an index can be expensive for the DB engine when the index becomes unbalanced - a recommendation there is to drop the index and recreate it | 14:32 |
hieplq | ok. i will try to run ANALYZEd and remove index they added | 14:32 |
hieplq | thanks @CarlosRuiz, will report when see something new | 14:32 |
CarlosRuiz | yw | 14:33 |
*** nmicoud has quit IRC | 14:46 | |
Not-7634 | [iDempiere] CarlosRuiz_globalqss pushed 1 commit to development [+2/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/ | 14:57 |
Not-7634 | [iDempiere] globalqss 6b72ce5 - IDEMPIERE-3221 Add ability to report/group by Parent Product Category on Invoice Detail & Margin | 14:57 |
Not-7634 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3221 status set to "Resolved" -assignee set to "Carlos Antonio Ruiz Gomez" -resolution set to "Fixed" | 14:57 |
Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3221 | 14:57 |
Not-7634 | [iDempiere] jenkins built #1814 completed (success) http://ci.idempiere.org/job/iDempiere/1814/ | 15:09 |
*** a42niem has quit IRC | 15:29 | |
*** a42niem has joined #idempiere | 15:30 | |
*** CarlosRuiz has quit IRC | 18:53 | |
*** a42niem has quit IRC | 21:48 | |
*** xapiens has joined #idempiere | 22:16 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!