General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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 :)
Yup. Netware. The bandwidth is quite good, and there are probably 5 people with the table open at the moment. It sounds like this is query time is normal. Thanks for your help.
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