If you remember some time ago I did some tests on the IsolatedStorage and the speed was not very impressive (it was 127 slower than the FileStream). In the new beta version there is a TREMENDOUS improvement. I rerun the old test in the new emulator and these are the results:
Dividing the two values 0.0632/1.1866=0.0532 which is almost the same with FileStream. At this point it does make sense implementing/porting a database engine on IsolatedStorage. Well done WP 7 Team on this aspect.
NAMASTE
I ran the SQLite for SP7 POC against the new beta version (with my edits made) and the speed of my query went from 150ms down to 7ms. Quite the improvement. I put the details here: http://diaryofacodemonkey.blogspot.com/2010/06/sqlite-for-wp7-proof-of-concept.html
ReplyDeleteSend me the source code of the tests you are doing and the results to dan.ardelean@gmail.com. I've done some improvments to the library and want to see if I get better results compared to yours.
ReplyDelete@Dan, send me your app and I'll run on the prototype device and let you know the results.
ReplyDeleteLorenzo please run the SqliteClient test application and tell me how fast it is for insert and select.
ReplyDeleteThanks
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete