Perfomance compare with sqlite

[hoang nguyen]

Did anyone has check performance between cbilte and sqllite?

I have sqlite db, i converted to cblite and check the smooth of apps.
I found that apps using sqlite seems have better performance and run more smooth than apps using cblite.

[Jens Alfke]

On Jul 10, 2014, at 7:25 PM, hoang nguyen <hu...@vpoint.com.vn> wrote:

I have sqlite db, i converted to cblite and check the smooth of apps.
I found that apps using sqlite seems have better performance and run more smooth than apps using cblite.

You’re comparing apples and oranges. SQLite is a lot lower level than Couchbase Lite; in particular, it doesn’t do synchronization or provide a object-oriented API.

Also, since Couchbase Lite currently uses SQLite to store its data, it can’t possibly be faster than raw SQLite. :)

If all you need to do is store data locally in a fixed schema and are willing to use a very low-level C API to do it (or a slightly higher-level OOP wrapper), then SQLite is a better bet.

—Jens