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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of ed.freed...@tac.com Sent: Friday, May 22, 2009 6:22 AM To: sqlite-users@sqlite.org 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 ed.freed...@tac.com 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
