|
Problem IT11956
|
Status: Closed |
QUERYING DATA COMPLETELY CACHED HAVING A LARGE NUMBER OF ITEMS IN AN "IN" CLAUSE CAN CAUSE SQLEXEC THREAD TO YIELD IMPROPERLY
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
A query in question had > 10,000 host variable values for a
column IN filter and was doing a sequential scan on a large
table. So when looking at rows to try and qualify for the
result set, much of the data in the table did not satisfy the IN
condition, and evaluating the expressions to determine the row
that didn't qualify was taking a lot of cpu time and so the
thread was not yielding frequently enough, which can negatively
impact the server. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* users having large host variables or constant values in a *
* query as "IN" clause. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.10.2015
09.06.2017
09.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
