On 12/31/07, Hugo Ferreira <[EMAIL PROTECTED]> wrote:

> Yes, indeed, it is doing a sequential scan according to EXPLAIN. Still, the
> slowness is unbelievable in such a small database. The whole db takes 11Mb,
> and doing a LEFT JOIN between a few hundred and a few thousand of rows on a
> "Core 2 Duo" taking 6 seconds is... I don't even know what it is :P There
> must be something very strange going on... I suppose it is not possible to
> create indexes on views, right?
>
> I'll play some more with queries and try to figure out if I can tweak this.
> If not, then I guess I'll unfortunately have to move to PostgreSQL :-(

If you haven't found this page yet, it may be useful:
http://sqlite.org/optoverview.html

If a client-server database engine like PostgreSQL is better suited to
your application, I'd probably use it anyway. SQLite is good, but it's
not a compact version of a major database engine.

If you're simply looking for something that's easily deployable, and
SQLite turns out to not meet your needs, there are other database
engines that might.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to