>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?
This is the approach to take.
Make sure you use Rushmore on those tables.