I have a strange behaviour of my Select statement.

I'm using this code to populate Grid control with data from Customer table:

strSQL = "SELECT .... FROM Customer WHERE  (ParentRefListID Is NULL)"

When I include all fields one by one in my strSQL then I get result pretty fast (4-5 seconds for 2000 records). In order to get only needed values and make it faster I exclude part of fields from Select statement. In this case I get result in 2-3 minutes. Why is that? In SQL Server, Access and all other databases I know, the less data you request the faster you get it. It's not working that way with QuickBooks and QODBC.

I'm using VB 2005

Thank you

Vlad

You haven't exactly shown what was slow, but using QODBC v8.00.00.234 I ran:

SELECT * FROM Customer WHERE ParentRefListID Is NULL

and

SELECT {fn Curtime()}, ListID, Name, FullName, IsActive FROM Customer WHERE ParentRefListID Is NULL

Query Result 54 rows
Start:  15:49:47
Finish: 15:49:47

and there where no difference I could see in the speed in returning the 54 rows.

This is the sample which takes too much time. I just excluded some fields:

I noticed one thing - if I remove fields from the end of the list, first the most last, then again the most last etc then there is no degradation in speed. If I remove any fild(s) from any other part of the list (beginning, middle part) then it slows down dramatically.

I'm using Version 7.10.00.231

Is it free? Or if not then how do I go back to my registered version?

Thank you

Vlad