Information générale
Catégorie:
Codage, syntaxe et commandes
The queries suggested by others should work fine. Your problem is almost certainly that the system is scrolling through too many child record to find the ones belonging to the parent. Make sure the way you are using your indexes is okay with Rushmore, which it probably is if you are just indexing on key values. It is, as someone said, also a good idea to index on Deleted(). If nothing else works, sum it by yourself with a SCAN FOR. Then, if that is very slow, I'd be pretty sure that your FOR clause is not Rushmore optimizable. Or else, you are running on a 386 with 8 megs of ram and you're almost out of harddrive space so you have a memory/file swapping problem. :)
Adam
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