>>The system I'm currently developing will eventually be using client-server data, but the initial implementation will be file-based. So it seemed like a perfect solution to use local views now, and 'switch' them to remote later. Except that the views are incredibly slow!
>>
>>The four tables take 3 seconds to open. Opening the four corresponding views (no joins, nodata, fully optimized) takes 20 seconds! (Subsequent requries are fast).
>>
>>It seems I'd be better off wihout the views, just use filter conditions on the main tables.
>>
>>Am I doing something obviously wrong? Is this the normal behavior of local views? If so, why would anyone make such a performance sacrifice to use them?
>
>Are these just direct views of one table (SELECT * FROM...) or are they multitable views? Are you filtering your views using WHERE and are you sure they're fully optimized?

One of the major reasons to use Local Views, is for people with older (2.x) systems that read data, and writing newer (VFP) systems that want to use and maybe update the older systems tables.. Thus, you would use a local view, to open and update the older tables (without modifying the structure, else they will become VFP style tables..)..

Always, when you are building views, make sure they are optimized!!

Thanx!

Tony Miller
Vancouver, Wa