I'm developing an application to run on an ARM-based PDA-like device. It's running Linux and I've got SQLite 3.4.1 installed.
I'm trying to optimize my insert statements (in a different discussion thread) I've gotten some good suggestions to use the PRAGMA statement to disable the syncronization. On my Shuttle running Fedora 3, I see insert times of ~0.2 ms. However, the same test application running on the PDA is taking ~25 ms for the same insert. The media doesn't appear to be that slow - writing the same insert statement to a text file takes ~0.2ms. Granted, there is more going on with the SQLite insert than the file right, but, I wouldn't expect such a discrepancy. Does anyone have any experience using SQLite and flash? Any particular settings that would be helpful? Thanks, Mark ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------