Hi!
Because VFP reads all information about views and tables into the memory. The more views you have in the database, for example, the slower database opening is. That is why read-only views are not recommended in the application, use direct query to tables instead (or SQL Pass-Through functions to send query to server if this database is for remote views). Try also to pack database (Cleanup it from menu when modifying, you require to open it when SET EXCLUSIVE is ON).
HTH.
>Morning
>
>Why does it take a second or two to open a Database - especially slow when accessing from a Server?
>
>Thanks
>Kev
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
