Thomas, Thank you for posting these results. I think they show that SQLite really is fast enough to work well with NS Basic.
> > >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 sch rieb 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.
