Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement