Hello all > 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 i like to comment on this one, my guess for the speed difference is: the difference is not that you are using Transactions or not but that without using explicit transactions every single query is wrapped into a transaction causing additional overhead -- Mit freundlichen Grüssen / with best regards Hannes Streicher mailto:[email protected] -- 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.
