This is due to horizontal dataset refinement. If you create an index
(descending) which will support this action then your performance problem
will be resolved.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "pmagor2001" <pmagor@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, January 17, 2002 12:30 AM
Subject: [IBO] Understanding the IB_MonitorDialog Output


> Hi all
>
> I am using the IB_MonitorDialog to help with the development of a
> program and I have question about its output.
>
> The following is in the log
>
> SELECT ALL transtable.*
> FROM transtable
> WHERE CUSTOMER < ? /* PRM_0 */ /* OLNK_CUSTOMER */
> ORDER BY CUSTOMER DESC
> , TRANS_ID DESC
> , INV_NUMBER DESC
>
> Now I recognise the field names (CUSTOMER, TRANS_ID and INV_NUMBER)
> and the table name (transtable) but what I don't recognise is the
> condition and the PRM_0 and OLNK_CUSTOMER. Can any one help me to
> identify why this query is generated? It's currently slowing down the
> program as it can take over a minute to run.
>
> Thanks in advance
> Peter Magor