General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
SET DELETED ON/OFF can have a big effect on opening a views with the NODATA clause.
Try opening the views two different ways...
With SET DELETED ON, and SET DELETED OFF.
Guy
>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
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