*** a42niem has joined #idempiere | 05:48 | |
*** nmicoud has joined #idempiere | 07:44 | |
*** CarlosRuiz has joined #idempiere | 07:53 | |
Not-a748 | [IDEMPIERE] soo.fang@gmail.com updated IDEMPIERE-3598 assignee set to "Soo Fang Lee" | 10:56 |
---|---|---|
Not-a748 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3598 | 10:56 |
Not-a748 | [IDEMPIERE] soo.fang@gmail.com updated IDEMPIERE-3598 Attachment set to "3598-1_5.1.patch" | 10:56 |
Not-a748 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3598 | 10:56 |
Not-a748 | [IDEMPIERE] soo.fang@gmail.com updated IDEMPIERE-3598 Attachment set to "3598-2_5.1.patch" | 10:56 |
Not-a748 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3598 | 10:57 |
Not-a748 | [IDEMPIERE] soo.fang@gmail.com updated IDEMPIERE-3598 assignee set to "hengsin" | 10:57 |
Not-a748 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3598 | 10:57 |
*** norbertbede has joined #idempiere | 11:10 | |
norbertbede | hi | 11:10 |
norbertbede | i have a performance issue on user save action. the next scenario: | 11:10 |
norbertbede | 1. yesterday we imported approx 120k leads | 11:11 |
norbertbede | 2. trying to change lead (ad_user) and java check other users by count (*) - 119k users has or hasn't same email pw combination | 11:12 |
norbertbede | MUser class, method before save > controll uniqe email+pw | 11:13 |
norbertbede | https://idempiere.atlassian.net/browse/IDEMPIERE-358 | 11:14 |
norbertbede | Check Email Unique when USE_EMAIL_FOR_LOGIN | 11:14 |
CarlosRuiz | Hi norbertbede - with such number of records in AD_User - I think it makes sense to create an index on AD_User.EMail - that must solve your problem | 11:15 |
CarlosRuiz | and must improve also the login time | 11:15 |
norbertbede | i have this index | 11:16 |
norbertbede | CREATE INDEX "ad_user_email" ON "adempiere"."ad_user" USING btree(email COLLATE "default" "pg_catalog"."text_ops" ASC NULLS LAST); | 11:16 |
CarlosRuiz | you can check if is being used with: | 11:19 |
CarlosRuiz | explain SELECT COUNT(*) FROM AD_User WHERE Password IS NOT NULL AND EMail='test@email.com' AND AD_Client_ID=? AND AD_User_ID!=100000 | 11:19 |
norbertbede | ok. let me check | 11:21 |
norbertbede | however not all leads has email | 11:21 |
norbertbede | Execution time: 16.162 ms | 11:22 |
norbertbede | we are studying the code sure | 11:22 |
norbertbede | we are restoring db. will check live data let you know bit later | 11:25 |
norbertbede | thanks for idea | 11:25 |
CarlosRuiz | yw | 11:26 |
*** aguerra has joined #idempiere | 13:30 | |
*** hriess has joined #idempiere | 13:58 | |
*** nmicoud has quit IRC | 16:20 | |
*** CarlosRuiz has quit IRC | 16:31 | |
*** norbertbede has quit IRC | 16:55 | |
*** norbertbede has joined #idempiere | 18:19 | |
*** CarlosRuiz has joined #idempiere | 19:14 | |
*** norbertbede has quit IRC | 20:24 | |
*** norbertbede has joined #idempiere | 20:28 | |
*** norbertbede has quit IRC | 20:33 | |
*** CarlosRuiz has quit IRC | 20:50 | |
*** aguerra has quit IRC | 21:35 | |
*** norbertbede has joined #idempiere | 22:59 | |
*** norbertbede has quit IRC | 23:17 | |
*** a42niem has quit IRC | 23:31 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!