Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Kevin,
When opening views, it matters if the underlying tables are already opened or not.
Further a view is in fact a SQL statement and even if NODATA is in effect, it still executes. When it executes it still downloads indexes needed to perform the joins. I don't know if this also applies to an DELETED() index tag. You might want to try it yourself.
Walter,
>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
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