Hi Edward I am using sqlite on an embedded application. I am using an SD card rather than flash, although I think you will encounter the same problems I did with the flash implementation.
I had to use the following Pragma's due to some major performance problems using the SD card. //PRAGMA Optimisations for SQLite $sql= "PRAGMA synchronous = 0"; // 2 = full, 1 = normal, 0 = off (optimal performance) $result = $dbh->query($sql); $sql= "PRAGMA temp_store = 2"; // 2 = temp_store memory, 1 = temp_store file $result = $dbh->query($sql); Other than that it runs quite well. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, May 22, 2009 6:22 AM To: [email protected] Subject: [sqlite] Sqlite3 on a linux/flash-based platform I'm interested in communicating with anyone who has experience developing sqlite3 databases on a flash file system on linux. I'm especially interested in the following: file system driver data integrity performance Edward P. Freedman T.A.C One High Street North Andover, MA 01845 1 (978) 975-9621 [email protected] Disclaimer: Any views expressed by me in this email are my own, and do not necessarily reflect the views of T.A.C _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
