Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement