At 11:32 28/03/2012, you wrote:
Hello, I'm doing some test with SQlite 3.7.11 in Windows Embedded industrial PC. I need to store data in a table very quickly. Let's say new data each 10 msec. I tryed with DB on disk but obviously was not possible to reach the correct performance. So I tryed with in-memory DB and in this case the performance results are good. The problem is that I can't share the in-memory database with other applications. I red a lot of article and documentation but I have not solved the problem. Maybe with temporary DB I can have the same performance and also I can share DB? Have you some suggestion?
DOn't know for windows embedded. I used Linux in embedded devices some years ago. I used a ramdisk and from time to time create/open a new db/table, swap insertions to new one and close the old one. Then a simple move from the ramdisk to server. The last thing i did was to drop sqlite from the device, write an app that export data in csv format and send it to server directly, this worked because moved the decission/analisys of data from th device to the server.
Simone Pietro Lossani Mezzomerico Italy _______________________________________________ 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
