Hello, after a little help from George (my NSBasic/CE got a bit rusty, I had to learn a few new features of version 8 first), I managed to run the performance tests on a Windows Mobile device, a t-Mobile MDApro, WM5 520MHz. Here are the first results: 1000 inserts - without transactions: 73s = 13 Inserts/s 1000 inserts - with 100 inserts/transaction: 3s = 333 Inserts/s same result with 1000 inserts/transaction! 10000 inserts - with 100 inserts/transaction: 33s = 303 inserts/transaction 10000 inserts - with 1000 inserts/transaction: 25s = 399 inserts/transaction (2 separate runs) 10000 inserts - with 10000 inserts/transaction: 24s = 416 inserts/s
So this shows that it's definitely worth using transactions from a performance point of view, if you have to execute a large number of updates to a database. I'm glad it also shows that the general behaviour of SQLite is similar on desktop and mobile devices, despite the huge differences in system and hardware (internal memory / hard disk). The number of updates you can group in 1 transaction depends on available memory I believe, and on the amount of data you're updating, but I have no numbers to support this assumption yet. I may run some further tests with varying table structures and amount of data inserted when I find the time, to get an idea. Here is the memory situation on my device during the tests: data memory: total 43,72MB in use 24,79MB free 18,93MB program memory: total 49,7MB in use 26,6MB free 23,1MB The size of the database is now 356K (with 10.000 records) I'll post the test program in the files section when I've done a bit of cleanup. Kind regards Thomas Am 25.02.2010 um 23:50PM schrieb George Henne: > Thanks for posting this - do you have any results from running it? > > George Henne > NS BASIC Corporation > http://www.nsbasic.com > > > > >Hello, > > > >This email message is a notification to let you know that > >a file has been uploaded to the Files area of the nsbasic-ce > >group. > > > > File : /SQLitePerformanceCE.zip > > Uploaded by : computerhusky <[email protected]> > > Description : SQLite Performance test with/without transactions > > > >You can access this file at the URL: > >http://groups.yahoo.com/group/nsbasic-ce/files/SQLitePerformanceCE.zip > > > >To learn more about file sharing for your group, please visit: > >http://help.yahoo.com/l/us/yahoo/groups/original/members/forms/ > >general.htmlfiles > > > >Regards, > > > >computerhusky <[email protected]> > > > > > > > > > > > > > >------------------------------------ > > > >Yahoo! Groups Links > > > > > > > > -- You received this message because you are subscribed to the Google Groups "nsb-ce" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nsb-ce?hl=en.
