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?