Hello,

   I have been testing the early build of Couchbase LIte .net and its seems 
to be dead slow. For obvious reasons that the profiling is not done yet. 
Thats fine.

Found using Intel VTune that its sqlite_step command which is hogging the 
time.

So I decided to add these two lines to the Couchbase Lite .net build and 
built by myself

* raw.sqlite3_exec(db, "PRAGMA synchronous = OFF");*
*raw.sqlite3_exec(db, "PRAGMA journal_mode = MEMORY");*

the performance has improved drastically.

but this is what I have build by myself. 

Does couchbase lite somehow allow us to change the configuration of sqlite?

And whether sqlite configure to  "PRAGMA synchronous = OFF" and "PRAGMA 
journal_mode = MEMORY" is safe?

Thanks

-Sherry


-- 
You received this message because you are subscribed to the Google Groups 
"Couchbase Mobile" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/mobile-couchbase/09cf91d4-8d0e-4d49-850e-456a565f752d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to