#idempiere IRC log for Saturday, 2016-10-15

*** silphium has joined #idempiere00:33
*** silphium has quit IRC00: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-322003: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-322003:25
Not-7634[IDEMPIERE] hieplq updated IDEMPIERE-322003: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-322003: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-322003:45
*** nmicoud has joined #idempiere04:51
Not-7634[iDempiere3.1Daily] jenkins built #95 completed (success) http://ci.idempiere.org/job/iDempiere3.1Daily/95/05:21
*** CarlosRuiz has joined #idempiere07:38
*** CarlosRuiz has quit IRC07:46
*** posde has quit IRC08:33
*** posde has joined #idempiere08:51
Not-7634[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-322009: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 - list09: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-7634Sales 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 Ruiz09:20
Not-7634[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-322009:20
*** CarlosRuiz has joined #idempiere09:20
*** posde has quit IRC09: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-322010:22
*** hieplq has joined #idempiere10:53
Not-7634[IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-3221 Add ability to report/group by Parent Product Category on Invoice Detail & Margin13:21
Not-7634[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-322113:21
*** hieplq has quit IRC13:42
*** hieplq has joined #idempiere13:58
hieplqanyone have experience to manage big table like AD_CHANGELOG and AD_ISSUE?14:01
CarlosRuizHi hieplq - what do you need with that?14:18
hieplqmy table is so big (16G) so insert and update take long time14:19
hieplqi 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
hieplqor use partition, with partition maybe i have change more things (sql to get history change of record, insert, update command)14:22
hieplqso i want to ask before decide14:22
CarlosRuizI usually delete AD_Issue periodically14:24
CarlosRuizAD_ChangeLog is a good source for auditing - but you could also take a backup of old records and preserve just recent14:25
CarlosRuizbut, 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 that14:27
hieplqbut my friend use oracle :(14:28
CarlosRuizupdate 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 ANALYZEd14:28
CarlosRuizyes - oracle must be even better for that14:28
CarlosRuiznow14:28
CarlosRuizboth, insert and update operations are affected by the number of indexes14:29
hieplqoh. so i should try run maintain database14:29
CarlosRuizthose two tables are not intended to be updated - so I think they must not be affected by slow updates14:31
hieplqah, they add two more index to AD_CHANGELOG14:31
hieplqah, it just affect when insert14:31
CarlosRuizmaintaining an index can be expensive for the DB engine when the index becomes unbalanced - a recommendation there is to drop the index and recreate it14:32
hieplqok. i will try to run ANALYZEd and remove index they added14:32
hieplqthanks @CarlosRuiz, will report when see something new14:32
CarlosRuizyw14:33
*** nmicoud has quit IRC14: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 & Margin14: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-322114:57
Not-7634[iDempiere] jenkins built #1814 completed (success) http://ci.idempiere.org/job/iDempiere/1814/15:09
*** a42niem has quit IRC15:29
*** a42niem has joined #idempiere15:30
*** CarlosRuiz has quit IRC18:53
*** a42niem has quit IRC21:48
*** xapiens has joined #idempiere22:16

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!