Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Bela,
Sorry, but i can't help when you about the question of the creation of cursors.
But, i can give you some ideas to perform your task.
1 - Use indexs on the fields you are using at your WHERE clauses (and JOIN, of course). ALthough VFP creates indexs if necessary, you will get a quicker query if you have indexs already created.
2 - Avoid the "SELECT * FROM ...". Everytime you know the fields you need, use it; don't use SELECT * too many times.
3 - Be carefull with cursors and Public Arrays or variables. As soon you don't need them, release them.
Well, hope you find your answer.
Good luck and have a nice year 2000, without bugs :)
Ricardo
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