Adding DO sort causes slows record reterival (ViP Specific)
At 03 MAR 1998 11:47:22AM [email protected] wrote:
Everytime I add a column to sort by in my Data Object the records returned takes 2 1/2min. If I remove the sort, record reterival only takes 2 seconds. This test is returning only two records. Am I doing something wrong or is there a fix for this.
At 03 MAR 1998 11:54AM [email protected] wrote:
Here is some additional information
Database being used: Btrieve 6.x
VIP Ver 2.1
Column being sorted is a Unique, non-modifiable field.
At 03 MAR 1998 05:16PM Stephen Bellefontaine Revelation wrote:
Hello Bart,
Take a look at the LastVendorString Property of the Data Object.
It is a string that represents the query that ViP most recently sent to a data source for the data object at run time.
In the case of ODBC it should return a SQL SELECT string, which may or may not contain a SORT BY condition, as well as a Selection Criteria.
This information will allow us to troubleshoot your issue further.
After the query executes, try executing the following code …
Query$=DataObjectRef.LastVendorString
Repost any more information you may have.
Hope this helps,
ViP/DX Tech Support