SQLite Connection or SQLite Async Connection

Question

I'm start using sqlite for wp8 , from this article

I found that there're 2 version of SQliteConnection here: async and non-async. While I'm using this for WP8, I want to use the async version for smooth performance, but it seem the Async-version class doesn't implement IDispose ( I can use Using for the non-async version). So what solution should I use here ?

Answer 1

I would involve also consider the size of the project and the scope of it, for example if its a small project then just use the simple, non-async, it's less code and easier to maintain, and most of the small operations happen in milliseconds.

If you want high performance, the go to async, write some extra code and get a better user experience.

Or maybe just use async for the large operations and non-async for the small ones?

I believe it's different for every project, and you could use a mixed approach sometimes, that's IMHO.