details:   https://code.openbravo.com/erp/devel/pi/rev/f6a4fd1a4a26
changeset: 20490:f6a4fd1a4a26
user:      Asier Lostalé <asier.lostale <at> openbravo.com>
date:      Wed May 29 12:16:05 2013 +0200
summary:   fixed bug 23934: sequential scan on AD_Session when logging in

diffstat:

 src-db/database/model/tables/AD_SESSION.xml |  3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diffs (13 lines):

diff -r 4057eab77422 -r f6a4fd1a4a26 src-db/database/model/tables/AD_SESSION.xml
--- a/src-db/database/model/tables/AD_SESSION.xml       Tue May 28 13:09:46 
2013 +0200
+++ b/src-db/database/model/tables/AD_SESSION.xml       Wed May 29 12:16:05 
2013 +0200
@@ -75,6 +75,9 @@
       <foreign-key foreignTable="AD_ORG" name="AD_SESSION_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <index name="AD_SESSION_ACTIVE_IDX" unique="false">
+        <index-column name="SESSION_ACTIVE"/>
+      </index>
       <index name="AD_SESSION_CREATED_IDX" unique="false">
         <index-column name="CREATED"/>
       </index>

------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to