Hello! I use the latest (3.6.11) version of the SQLite dll in a WinXP Application. The main task of this application is to store values from a sensor-hardware in multiple databases. Each DB contains a subset from the Values. I tested serveral design options. One is to read all values from the senor hardware and split them to the different DBs.
operational sequence: --main-- create and init 2 databases in the main-function. --main-- create 2 Threads and pass the 2 DB-handle parameter (one thread per DB!!!) --thread-- fill the DBs with the values In the last step occurs an Error. Sometimes the threads dont write in the correct DB!!! I inserted 20000 values in one DB. DB0.db have to look like this: index | subid | time | 0.0 <--- DB1.db have to look like this: index | subid | time | 1.0 <--- What i got was: DB0.db: sqlite> SELECT * FROM ArchiveLog WHERE Value==1; 11438|37|33:10.897|1.0 14180|19|33:13.647|1.0 19854|29|33:19.241|1.0 DB1.db sqlite> SELECT * FROM ArchiveLog WHERE Value==0; 18719|16|33:18.101|0.0 The other Values in the DBs are correct. Best regards! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
