Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
Clear All
new posts
Previous template Next
    #1

    Usage of Database Index to improve Live Scrolling?

    Hi there,

    we are using the SmartGWT Power Edition.

    We use a ListGrid (com.smartgwt.client.widgets.grid.ListGrid) with Live Scrolling. Our table has 10.000 to 1.000.000 entries. After scrolling, the reloading takes some time (about two seconds).
    I think we maybe can improve it by using Indexes for our table? Or improve some SQL statement?

    Do you have any recommendations how to improve the "live scrollling" performance? (I attach a snippet of our log file, maybe this helps)
    Would be great...

    If you need more information, tell me!


    Best regards,
    Kai

    Code:
    === 2010-11-17 15:47:55,675 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
=== 2010-11-17 15:47:55,675 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
[WARN] 401 - POST /E2E_VoiceTM/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2010-08-03&isc_xhr=1&isc_tnum=11 (127.0.0.1)
   Request headers
      Host: 127.0.0.1:8888
      User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12
      Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      Accept-Language: en-us,en;q=0.5
      Accept-Encoding: gzip,deflate
      Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
      Keep-Alive: 115
      Connection: keep-alive
      Content-Type: application/x-www-form-urlencoded; charset=UTF-8
      Referer: http://127.0.0.1:8888/E2E_VoiceTM.html?gwt.codesvr=127.0.0.1:9997
      Content-Length: 1025
      Cookie: JSESSIONID=9dwwu74qs7f1; isc_cState=ready
      Pragma: no-cache
      Cache-Control: no-cache
   Response headers
      X-Included-Test2: true
      X-Included-Test: true
      WWW-Authenticate: NTLM
      Content-Length: 0
=== 2010-11-17 15:47:55,678 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
=== 2010-11-17 15:47:55,678 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
[WARN] 401 - POST /E2E_VoiceTM/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2010-08-03&isc_xhr=1&isc_tnum=11 (127.0.0.1)
   Request headers
      Host: 127.0.0.1:8888
      User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12
      Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      Accept-Language: en-us,en;q=0.5
      Accept-Encoding: gzip,deflate
      Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
      Keep-Alive: 115
      Connection: keep-alive
      Content-Type: application/x-www-form-urlencoded; charset=UTF-8
      Referer: http://127.0.0.1:8888/E2E_VoiceTM.html?gwt.codesvr=127.0.0.1:9997
      Content-Length: 1025
      Cookie: JSESSIONID=9dwwu74qs7f1; isc_cState=ready
      Pragma: no-cache, no-cache
      Cache-Control: no-cache, no-cache
      Authorization: NTLM TlRMTVNTUAABAAAAB4IIAAAAAAAAAAAAAAAAAAAAAAA=
   Response headers
      X-Included-Test2: true
      X-Included-Test: true
      WWW-Authenticate: NTLM TlRMTVNTUAACAAAAAAAAAAAAAAABAgAA56PK2Bf8aYU=
      Content-Length: 0
      Expires: Thu, 01 Jan 1970 00:00:00 GMT
      Set-Cookie: JSESSIONID=1h0g7xvmnd3s0;Path=/
=== 2010-11-17 15:47:55,682 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
=== 2010-11-17 15:47:55,682 [0-34] INFO  RequestContext - URL: '/E2E_VoiceTM/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12': Moz (Gecko) with Accept-Encoding header
Gefundene Benutzer Rolle: DueRead
Gefundene Benutzer Rolle: PmxRead
Gefundene Benutzer Rolle: NrtRead
Gefundene Benutzer Rolle: VipWrite
Gefundene Benutzer Rolle: DueWrite
Gefundene Benutzer Rolle: PmxWrite
Gefundene Benutzer Rolle: Admin
=== 2010-11-17 15:47:55,906 [0-34] WARN  RPCManager - client/server version mismatch.  Client is version: SC_SNAPSHOT-2010-08-03, server is version: SC_SNAPSHOT-2010-08-23 - mixing different client/server versions is generally not supported.  If you've installed a more recent client version, try clearing the browser cache and reloading the page.
=== 2010-11-17 15:47:55,906 [0-34] WARN  RPCManager - client/server version mismatch.  Client is version: SC_SNAPSHOT-2010-08-03, server is version: SC_SNAPSHOT-2010-08-23 - mixing different client/server versions is generally not supported.  If you've installed a more recent client version, try clearing the browser cache and reloading the page.
=== 2010-11-17 15:47:55,973 [0-34] DEBUG XML - Parsed XML from (in memory stream): 65ms
=== 2010-11-17 15:47:55,973 [0-34] DEBUG XML - Parsed XML from (in memory stream): 65ms
=== 2010-11-17 15:47:55,974 [0-34] DEBUG RPCManager - Processing 1 requests.
=== 2010-11-17 15:47:55,974 [0-34] DEBUG RPCManager - Processing 1 requests.
=== 2010-11-17 15:47:55,974 [0-34] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
        dataSource:"DEFECT_INFO_ALL",
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    startRow:5364,
    endRow:5439,
    componentId:"isc_ListGrid_1",
    appID:"builtinApplication",
    operation:"DEFECT_INFO_ALL_fetch",
    oldValues:{
    }
}
=== 2010-11-17 15:47:55,974 [0-34] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
    },
    operationConfig:{
        dataSource:"DEFECT_INFO_ALL",
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    startRow:5364,
    endRow:5439,
    componentId:"isc_ListGrid_1",
    appID:"builtinApplication",
    operation:"DEFECT_INFO_ALL_fetch",
    oldValues:{
    }
}
=== 2010-11-17 15:47:55,974 [0-34] INFO  IDACall - Performing 1 operation(s)
=== 2010-11-17 15:47:55,974 [0-34] INFO  IDACall - Performing 1 operation(s)
=== 2010-11-17 15:47:55,975 [0-34] WARN  DataSourceDMI - DataSource DEFECT_INFO_ALL, operationId DEFECT_INFO_ALL_fetch: Found a 'methodName' (fetch) on the serverObject AND a 'serverMethod' (fetch) on the operationBinding. serverObject.methodName takes precedence: calling fetch
=== 2010-11-17 15:47:55,975 [0-34] WARN  DataSourceDMI - DataSource DEFECT_INFO_ALL, operationId DEFECT_INFO_ALL_fetch: Found a 'methodName' (fetch) on the serverObject AND a 'serverMethod' (fetch) on the operationBinding. serverObject.methodName takes precedence: calling fetch
=== 2010-11-17 15:47:55,975 [0-34] DEBUG AppBase - [builtinApplication.DEFECT_INFO_ALL_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2010-11-17 15:47:55,975 [0-34] DEBUG AppBase - [builtinApplication.DEFECT_INFO_ALL_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2010-11-17 15:47:55,975 [0-34] DEBUG AppBase - [builtinApplication.DEFECT_INFO_ALL_fetch] No public zero-argument method named '_DEFECT_INFO_ALL_fetch' found, performing generic datasource operation
=== 2010-11-17 15:47:55,975 [0-34] DEBUG AppBase - [builtinApplication.DEFECT_INFO_ALL_fetch] No public zero-argument method named '_DEFECT_INFO_ALL_fetch' found, performing generic datasource operation
=== 2010-11-17 15:47:55,976 [0-34] INFO  SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Performing fetch operation with
	criteria: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{operator:"or",_constructor:"AdvancedCriteria",criteria:[{operator:"contains",fieldName:"DEF_ASA2",value:"NRT"},{operator:"contains",fieldName:"DEF_ASA",value:"EAS"},{operator:"contains",fieldName:"DEF_ASA",value:"PMXAS"},{operator:"contains",fieldName:"DEF_ASA",value:"BAAS"}]},{},{operator:"iNotContains",fieldName:"DEF_SEVERITY",value:"CLEAR"}]}	values: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{operator:"or",_constructor:"AdvancedCriteria",criteria:[{operator:"contains",fieldName:"DEF_ASA2",value:"NRT"},{operator:"contains",fieldName:"DEF_ASA",value:"EAS"},{operator:"contains",fieldName:"DEF_ASA",value:"PMXAS"},{operator:"contains",fieldName:"DEF_ASA",value:"BAAS"}]},{},{operator:"iNotContains",fieldName:"DEF_SEVERITY",value:"CLEAR"}]}
=== 2010-11-17 15:47:55,976 [0-34] INFO  SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Performing fetch operation with
	criteria: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{operator:"or",_constructor:"AdvancedCriteria",criteria:[{operator:"contains",fieldName:"DEF_ASA2",value:"NRT"},{operator:"contains",fieldName:"DEF_ASA",value:"EAS"},{operator:"contains",fieldName:"DEF_ASA",value:"PMXAS"},{operator:"contains",fieldName:"DEF_ASA",value:"BAAS"}]},{},{operator:"iNotContains",fieldName:"DEF_SEVERITY",value:"CLEAR"}]}	values: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{operator:"or",_constructor:"AdvancedCriteria",criteria:[{operator:"contains",fieldName:"DEF_ASA2",value:"NRT"},{operator:"contains",fieldName:"DEF_ASA",value:"EAS"},{operator:"contains",fieldName:"DEF_ASA",value:"PMXAS"},{operator:"contains",fieldName:"DEF_ASA",value:"BAAS"}]},{},{operator:"iNotContains",fieldName:"DEF_SEVERITY",value:"CLEAR"}]}
=== 2010-11-17 15:47:55,976 [0-34] WARN  SQLWhereClause - [builtinApplication.DEFECT_INFO_ALL_fetch] no column name for field named: null, field2ColumnMap: {
    DEF_LAC:"DEF_LAC",
    DEF_NTYP:"DEF_NTYP",
    DEF_PROBLEM_OCCURRENCES:"DEF_PROBLEM_OCCURRENCES",
    DEF_DESCRIPTION:"DEF_DESCRIPTION",
    DEF_ASA:"DEF_ASA",
    DEF_SEVERITY:"DEF_SEVERITY",
    DEF_USER_TEXT:"DEF_USER_TEXT",
    DEF_PROBLEM_STATUS:"DEF_PROBLEM_STATUS",
    DEF_ASA2:"DEF_ASA2",
    DEF_MESSAGE_NUMBER:"DEF_MESSAGE_NUMBER",
    DEF_ORIGINAL_EVENT_TIME:"DEF_ORIGINAL_EVENT_TIME",
    DEF_ADVISORY:"DEF_ADVISORY",
    DEF_PROBABLE_CAUSE:"DEF_PROBABLE_CAUSE",
    DEF_SIMILAR_ALARMS:"DEF_SIMILAR_ALARMS",
    DEF_VNK_TYPE:"DEF_VNK_TYPE",
    DEF_TIMESTAMP:"DEF_TIMESTAMP",
    DEF_ALARM_ID:"DEF_ALARM_ID",
    DEF_VIP_INFO:"DEF_VIP_INFO",
    DEF_SLA:"DEF_SLA",
    DEF_CRETIMESTAMP:"DEF_CRETIMESTAMP",
    DEF_RENR:"DEF_RENR",
    DEF_VSTKNR:"DEF_VSTKNR",
    DEF_SNL_KEY:"DEF_SNL_KEY",
    DEF_CLEAR_DATE:"DEF_CLEAR_DATE",
    DEF_GROUP_NUMBER:"DEF_GROUP_NUMBER",
    DEF_DN:"DEF_DN",
    DEF_RUFTABELLE_COLLECTION:"DEF_RUFTABELLE_COLLECTION",
    DEF_REASON:"DEF_REASON"
}
=== 2010-11-17 15:47:55,976 [0-34] WARN  SQLWhereClause - [builtinApplication.DEFECT_INFO_ALL_fetch] no column name for field named: null, field2ColumnMap: {
    DEF_LAC:"DEF_LAC",
    DEF_NTYP:"DEF_NTYP",
    DEF_PROBLEM_OCCURRENCES:"DEF_PROBLEM_OCCURRENCES",
    DEF_DESCRIPTION:"DEF_DESCRIPTION",
    DEF_ASA:"DEF_ASA",
    DEF_SEVERITY:"DEF_SEVERITY",
    DEF_USER_TEXT:"DEF_USER_TEXT",
    DEF_PROBLEM_STATUS:"DEF_PROBLEM_STATUS",
    DEF_ASA2:"DEF_ASA2",
    DEF_MESSAGE_NUMBER:"DEF_MESSAGE_NUMBER",
    DEF_ORIGINAL_EVENT_TIME:"DEF_ORIGINAL_EVENT_TIME",
    DEF_ADVISORY:"DEF_ADVISORY",
    DEF_PROBABLE_CAUSE:"DEF_PROBABLE_CAUSE",
    DEF_SIMILAR_ALARMS:"DEF_SIMILAR_ALARMS",
    DEF_VNK_TYPE:"DEF_VNK_TYPE",
    DEF_TIMESTAMP:"DEF_TIMESTAMP",
    DEF_ALARM_ID:"DEF_ALARM_ID",
    DEF_VIP_INFO:"DEF_VIP_INFO",
    DEF_SLA:"DEF_SLA",
    DEF_CRETIMESTAMP:"DEF_CRETIMESTAMP",
    DEF_RENR:"DEF_RENR",
    DEF_VSTKNR:"DEF_VSTKNR",
    DEF_SNL_KEY:"DEF_SNL_KEY",
    DEF_CLEAR_DATE:"DEF_CLEAR_DATE",
    DEF_GROUP_NUMBER:"DEF_GROUP_NUMBER",
    DEF_DN:"DEF_DN",
    DEF_RUFTABELLE_COLLECTION:"DEF_RUFTABELLE_COLLECTION",
    DEF_REASON:"DEF_REASON"
}
=== 2010-11-17 15:47:55,988 [0-34] INFO  SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
=== 2010-11-17 15:47:55,988 [0-34] INFO  SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
=== 2010-11-17 15:47:55,989 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
=== 2010-11-17 15:47:55,989 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
=== 2010-11-17 15:47:55,989 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Eval'd row count query: SELECT COUNT(*) FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:55,989 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] Eval'd row count query: SELECT COUNT(*) FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:56,135 [0-34] DEBUG PoolableSQLConnectionFactory - [builtinApplication.DEFECT_INFO_ALL_fetch] Returning pooled Connection
=== 2010-11-17 15:47:56,135 [0-34] DEBUG PoolableSQLConnectionFactory - [builtinApplication.DEFECT_INFO_ALL_fetch] Returning pooled Connection
=== 2010-11-17 15:47:56,136 [0-34] INFO  SQLDriver - [builtinApplication.DEFECT_INFO_ALL_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:56,136 [0-34] INFO  SQLDriver - [builtinApplication.DEFECT_INFO_ALL_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:56,166 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] JDBC driver windowed select rows 5364->5439, result size 75. Query: SELECT DEFECT_INFO.DEF_LAC, DEFECT_INFO.DEF_NTYP, DEFECT_INFO.DEF_PROBLEM_OCCURRENCES, DEFECT_INFO.DEF_DESCRIPTION, DEFECT_INFO.DEF_ASA, DEFECT_INFO.DEF_SEVERITY, DEFECT_INFO.DEF_USER_TEXT, DEFECT_INFO.DEF_PROBLEM_STATUS, DEFECT_INFO.DEF_ASA2, DEFECT_INFO.DEF_MESSAGE_NUMBER, DEFECT_INFO.DEF_ORIGINAL_EVENT_TIME, DEFECT_INFO.DEF_ADVISORY, DEFECT_INFO.DEF_PROBABLE_CAUSE, DEFECT_INFO.DEF_SIMILAR_ALARMS, DEFECT_INFO.DEF_VNK_TYPE, DEFECT_INFO.DEF_TIMESTAMP, DEFECT_INFO.DEF_ALARM_ID, DEFECT_INFO.DEF_VIP_INFO, DEFECT_INFO.DEF_SLA, DEFECT_INFO.DEF_CRETIMESTAMP, DEFECT_INFO.DEF_RENR, DEFECT_INFO.DEF_VSTKNR, DEFECT_INFO.DEF_SNL_KEY, DEFECT_INFO.DEF_CLEAR_DATE, DEFECT_INFO.DEF_GROUP_NUMBER, DEFECT_INFO.DEF_DN, DEFECT_INFO.DEF_RUFTABELLE_COLLECTION, DEFECT_INFO.DEF_REASON FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:56,166 [0-34] DEBUG SQLDataSource - [builtinApplication.DEFECT_INFO_ALL_fetch] JDBC driver windowed select rows 5364->5439, result size 75. Query: SELECT DEFECT_INFO.DEF_LAC, DEFECT_INFO.DEF_NTYP, DEFECT_INFO.DEF_PROBLEM_OCCURRENCES, DEFECT_INFO.DEF_DESCRIPTION, DEFECT_INFO.DEF_ASA, DEFECT_INFO.DEF_SEVERITY, DEFECT_INFO.DEF_USER_TEXT, DEFECT_INFO.DEF_PROBLEM_STATUS, DEFECT_INFO.DEF_ASA2, DEFECT_INFO.DEF_MESSAGE_NUMBER, DEFECT_INFO.DEF_ORIGINAL_EVENT_TIME, DEFECT_INFO.DEF_ADVISORY, DEFECT_INFO.DEF_PROBABLE_CAUSE, DEFECT_INFO.DEF_SIMILAR_ALARMS, DEFECT_INFO.DEF_VNK_TYPE, DEFECT_INFO.DEF_TIMESTAMP, DEFECT_INFO.DEF_ALARM_ID, DEFECT_INFO.DEF_VIP_INFO, DEFECT_INFO.DEF_SLA, DEFECT_INFO.DEF_CRETIMESTAMP, DEFECT_INFO.DEF_RENR, DEFECT_INFO.DEF_VSTKNR, DEFECT_INFO.DEF_SNL_KEY, DEFECT_INFO.DEF_CLEAR_DATE, DEFECT_INFO.DEF_GROUP_NUMBER, DEFECT_INFO.DEF_DN, DEFECT_INFO.DEF_RUFTABELLE_COLLECTION, DEFECT_INFO.DEF_REASON FROM XYZ_SCHEMA.DEFECT_INFO WHERE (((DEFECT_INFO.DEF_ASA2 LIKE '%NRT%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA2 IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%EAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%PMXAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL) OR (DEFECT_INFO.DEF_ASA LIKE '%BAAS%' {ESCAPE '\'} AND DEFECT_INFO.DEF_ASA IS NOT NULL)) AND NOT(LOWER(DEFECT_INFO.DEF_SEVERITY) LIKE LOWER('%clear%') {ESCAPE '\'} AND DEFECT_INFO.DEF_SEVERITY IS NOT NULL))
=== 2010-11-17 15:47:56,391 [0-34] INFO  DSResponse - [builtinApplication.DEFECT_INFO_ALL_fetch] DSResponse: List with 75 items
=== 2010-11-17 15:47:56,391 [0-34] INFO  DSResponse - [builtinApplication.DEFECT_INFO_ALL_fetch] DSResponse: List with 75 items
=== 2010-11-17 15:47:56,392 [0-34] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2010-11-17 15:47:56,392 [0-34] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2010-11-17 15:47:56,393 [0-34] DEBUG RPCManager - DMI response, dropExtraFields: true
=== 2010-11-17 15:47:56,393 [0-34] DEBUG RPCManager - DMI response, dropExtraFields: true
=== 2010-11-17 15:47:56,608 [0-34] INFO  Compression - /E2E_VoiceTM/sc/IDACall: 56171 -> 2267 bytes
=== 2010-11-17 15:47:56,608 [0-34] INFO  Compression - /E2E_VoiceTM/sc/IDACall: 56171 -> 2267 bytes
    Tags: None
    #2
    We do support the idea of limiting SQL queries to improve performance with large resultsets. This support is extremely database-specific, and in the case of Oracle is switched off by default because the technique we use doesn't work in certain complex cases. To switch it on, add the following line to your server.properties file:
    Code:
    sql.Oracle.supportsSQLLimit: true
    As noted, it is possible that this will cause problems with certain queries. If you encounter problems, please let us know - providing an sqlLimit strategy for ALL queries on Oracle is not on the current roadmap, but if it is important to you we could consider it as a feature sponsorship.

    Comment

    Previous template Next
    Working...
    X