On Wed, 6 Oct 2004 12:48:57 +0100, David Cantrell david@cantrell.org.uk wrote:
It's not as fast as (eg) Sybase for what I want to do, partly I think because SQLite has no concept of data types, and so doesn't treat ints (which is what I mostly search on) in the most efficient manner.
I too just discovered that SQLite is not a replacement for a proper database. I wanted to use it as a replacement for some temporary tables put into a Sybase database. Unfortunately SQLite was unable to do the same maths as Sybase and I got the wrong answers. Will that matter for an OpenGuides installation? I don't really know.
This doesn't really help answer the question "Does SQLite scale?" but it may push the original poster towards using a proper RDBMs rather than SQLite.
Alex