General information
Category:
Coding, syntax & commands
Randall,
>>I have noticed that if I use a SELECT-SQL like:
>>SELECT * FROM TABLE , I get the result pretty fast.
VFP is building a set of pointers to TABLE... its not really building a new table/cursor.
>>When ever I complicate things as in:
>>SELECT * FROM TABLE ;
WHERE BETWEEN(DATE,DATE1,DATE2) AND INLIST(TRANCODE,'26','27') ;
INTO TABLE2
>>Things slow down to a point wher you think it is never going to get the data I requested. all of the tables of the tables are out on the network server. I have noticed that sometimes it makesa difference if I bring the results tabel over on the users PC. Any way to get around this problem? I have indexes on the tables for that items I usally ask for. I read somewhere once that you can open and order the table ahead o time and it helps the SQL do it's thing. IS this true?
Kinda. In your example, if you made indexes on the DATE and TRANCODE fields you'd be amazed at how fast it gets. But you shouldn't have to set the order to the corresponding TAG before you run the query.
Regards,
Thom C.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only