Using SQlite in c#

  • Thread starter Thread starter Rob Stevens
  • Start date Start date
most tables have thousands of records but there are a few tables that
store data in a ridiculously normalized form and end up with hundreds
of millions of records. All worked wonderfully in SQLite. The
largest table actually ended up causing us to have 30 second command
timeout problems with MSSQL and we had to re-write the query and run
two separate queries, whereas SQLite handled the original query very
efficiently.
Click to expand...

sounds impressive; don't think I'd use it multi-user ... but it makes you
wonder (again) about these bloated beasts from MS and all the others ...
 
Back
Top