General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Evan,
Is your table on a network drive ?
This could have a huge impact depending on network traffic...
I just tried a simple query on a table with over 1,000,000 records
and it took close to 15 seconds (on the network, with maybe 50 users having
the table opened at the moment) so maybe your 5-7 seconds
is not so bad :)
HTH
Pascal
Previous
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