From: Robert Latest on
Hello all,

does anybody have experience with the relative performance of these two
RDB engines? All I need is a local database.

Currently my (Python) app uses the sqlite3 module, but as the database
grows, speed slowly becomes a factor. The database contains several
tables, the largest of which has some 7M entries, and the database file
size is about 1GB.

Before I make a software installation request to our notoriously
sluggish IT department, and before I adapt my code to use SQL Server
(via ODBC data source, I suppose) I would appreciate some hint on
whether this would improve performance.

BTW, how come that the SQL Server Express installer is 230MB whereas
sqlite is a mere 1MB? The usual Microsoft bloat?

robert