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
>
>Kevin,
>IMHO these results only indicate a slow network connection.
>Cetin
I also think this is due to a very slow network connection.
You can better do your tests on a local machine with no other programs open, as they may affect the speed.
You could think of opening a lot of views. Or opening and closing them in a loop.
Test it a few times, because Windows will stop operating sometimes for about 100 - 200 ms
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