>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)