On Tue, May 31, 2011 at 12:30:59 -0700, Roger Binns wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 05/31/2011 12:18 PM, Jan Hudec wrote:
> > and calculates them again.
>
> Have you considered using virtual tables so that the calculations are done
> on access as needed rather than up front?
That would not help. The whole point is that the result of each step is
cached, so it does not have to be calculated again next time unless it's
definition has changed (which it however does, because a lot of new features
are being added). Some steps involve quite a lot of work on the C++ side and
while others are implemented completely in SQL, they involve very complex
joins that would trash the caches (already set to 0.5GiB and I still suspect
it's not enough) if they were to be expanded into the query using it.
Regards,
Jan
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
