Re: [sqlite] Views and performances...

2004-08-12 Thread Andrew Piskorski
On Thu, Aug 12, 2004 at 03:38:21PM +0100, Christian Smith wrote: > AFAIK, views are compiled into their query definitions when executing a > statement, so once the compilation is done, performance should be > identical to their raw query form. > In short, create a view if you have a common

[sqlite] Views and performances...

2004-08-11 Thread Paolo Vernazza
Hi, I would like to know if using views instead of queries has some performance advantages. If I must perform many times the same query (a select with a complex where clause), is it better to have a precompiled query or to create a view? Thanks Paolo