Hi, I use sqlite (v3.7.9) in a Linuxmint environment to act as gateway for, on one side, a dozen of users give control request via TCPIP, Bluetooth HTTP and Linux Pipe. On the other side, via RS232 and Zigbee to control some 30 devices according to the request. All activities, user requests and device feedback are written to the database which is about 2.5MB and the entry is at about one database read/write in one/two seconds. The size of database will not increase as a fixed amount of entries are stayed in the database, all other written to text log file.
I have tried to use: pragma cache_size=3000 and executed the statement after database has been opened. My understanding is that this statement would give 3MB cache size to keep all data in the memory and reduced hard disk access. However the hard disk access seem still there with disk hamming rise up and down when write to database. Perhaps I misunderstood what pragma cache does, please advice. I have also explored the possbility of open database in :Memory: but could not find how this would be linked to the hard disk database. Are there facilities to open a hard disk database and keep all in memory, operate the memory db using normal sqlite statements, and later save it back to hard disk? That sound like a perfect solution. kfl. (Hong Kong). ---------------------------------------------------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
