General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Pondering Rushmore & My Table...
I have a table of "Work Orders" containing about 30,000 records. Most of the work orders are 'complete', so I have a logical field indicating True or False on completion. For example, I may have 62 orders in use, and 29938 orders completed.
My selects (over a 10baseT network) are somewhat slow and causing heavy network traffic (around 7 seconds to query the table for uncompleted orders).
There was an article in FoxPro Advisor discussing Rushmore optimization, and I think it indicated that an index on a logical field with such a lopsided distribution would cause a substantial amount of the index to be loaded across the network to the client machine.
Is there a 'proper' way to speed up these queries?
Thanks,
Chris
Next
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