----- Original Message ----- From: "Mateusz Łoskot" <[EMAIL PROTECTED]> Sent: Wednesday, March 17, 2004 12:33 PM Subject: [sqlite] SQLite & Big Database
> So, has anyone work with such big databases in SQLite ? > I'm looking for some hints and tips about that. I posted a message last night about my "large" database test. I found that setting the synchronous = OFF pragma and, more importantly, using transactions when loading large amounts of data would result in the best performance. > I've just moved one table from my "Big" database. There are about 11000 > of records and as I see SQLite database takes about 2,7 MB. The test I ran consisted of about 2 million records and resulted in a database size of about 695 MB (one table, without any indexes). The "raw" data I was importing from consisted of about 360 MB. After using transactions I found the speed to be good, but the size overhead a little puzzling. // CHRIS --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
