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
Just tested it
Opening a view with nodata is about 30 to 40% slower then opening a table (with the same structure and data, cause the view is a select all from the table.)
With the data it is about 40 to 50 % slower.
Setting deleted on or off doesn't affect the results.
I think opening a view takes longer, because the view also opens the assoctiated table(s). (Even with nodata)
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