Hi I use sqlite as database for my website develop using php and a c program keep receiving data from socket in multithread environment, and insert the data into multiple sqlite database by month . For example if the data is January data , then insert into January sqlite db and so on ...
Because the sqlite support multiple read and single write, this will reduce the sqlite busy . So i split the database into multiple database by month . Then i use attach to join multiple database for reporting purpose in php . (Refer to the attahment for more detail) This is the correct design for sqlite to split database into multiple sqlite file and access by multiple application? I also experience db corrupt . This design cause the DB corrupt ?
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
