SQL Server Express vs. sqlite

  • Follow


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
0
Reply Robert 5/4/2010 5:41:28 PM


0 Replies
487 Views

(page loaded in 0.045 seconds)

Similiar Articles:













7/23/2012 5:25:38 PM


Reply: