General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I conducted a speed test on opening a database, some tables and some views, here were my results (from an NT Server):
1 Database 1 Second
8 Tables(some free, some from database 12 Seconds
3 Views (with NODATA) 18 Seconds
My main concern is the views, how come the views take longer to open the tables even with NODATA issued? surely they should be quicker - or is it not?
Comments welcome
Kev
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