Hello. I am an elementary programmer in Korea.
My company uses SQLite for some kinds of project. We use it without any problems. but recently we got a problem, so I searched solutions from internet. but I couldn't find it. so I need helps and contact you. In my situation, our project is many people can SELECT some data from database file by using multi-threads. As I know, SQLite can perform the request after former request finished. The request for 'SELECT data' locks database file and after doing all request, it unlocks the file. We don't have any problem on Window server, but we get a problem on Unix server. When we use our project on Unix server, if more than 3 requests per second occur, database file don't unlock and we get "SQLite_BUSY". then the server is down. so in this situation, can I unlock the 'LOCK' forcibly by using command? If I can do that, how can I do it? or we only use select query from SQLite, so can we make database file never unlock? and If Using SQLite has differences between on Window server and Unix server, Please let me know it. Thank you for read my letter. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
