Sqlite and SDCARD

Hi,

I'm building a data log system, so I'll need a lot of space. Thus I'm using
a SDCARD to store my sqlite database. First, I did some tests, and
implemented my system without SDCARD, the sqlite database was on flash
(/home/eduardo/bd). The data access speed was very fast. When I switched
the database to sdcard, data access speed was increased by 3 or more times
with the same sql insert operation...

As first option, I read about some optimizations on sqlite:
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#intro

cache_size: I increased from 2000 to 10000.
synchronous: I can't change, I need this confirmation...
count_changes: I'll try
temp_store: I tried to change, but no effect (I think I missed something,
I'll check again)

Unfortunately I can't change synchronous because I need to guarantee data
was written on db.

Has someone the same problem? 
How to solve? 

My second option is to build a "cache" on flash, and copy it to SDCARD as
soon as possible to software.

Thanks in advance.

Using a media like SD card has always the risk of losing data. Even if you
mount it synchronous! And using your local flash memory as a cache will
ruin it in a short time.

Hi Juergen,

Thanks for your response. I think I'm going to use the cache option. Do you
know if is there any way to do it automatically or I'll need to do this
operation with my software?

regards