General information
Category:
Coding, syntax & commands
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
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