Changes between Version 1 and Version 2 of Ticket #114


Ignore:
Timestamp:
09/18/2012 05:17:09 PM (14 years ago)
Author:
huangzhong
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #114 – Description

    v1 v2  
    11* 背景 
    22商城oracle版建全量索引时是把将近100万条数据(索引用到的所有字段)全部一次性查询得到,虽然减少了访问数据库的次数,但对应用的压力很大,全量索引时间大概是20分钟。 
     3 
     4{{{ 
     5presta = con.prepareStatement(getSelectCProductSql(TYPE_ALL)); 
     6res = presta.executeQuery(); 
     7}}} 
     8 
    39 
    410* 优化