[DB-SIG] apsw+sqlite

[mfmorss at aep.com]

Does anybody have any experience with apsw and sqlite?

Using the latest versions of both, we are running into "illegal
instruction" errors when we do a join on a large (2,000,000+ records) data
base.  Our working assumption is that this symptom results from a memory
leak.  We do not get the same symptom when we use the pysqlite interface
instead of apsw.

We prefer to use apsw because it is leaner, and apparently faster, than
pysqlite.

Mark F. Morss
Principal Analyst, Market Risk
American Electric Power
Columbus, Ohio