when using sqlite, it waits 0 seconds when another transaction is active.

anyone have a sample code to avoid to get

"database is locked" when PHP + PDO + sqlite3?

The expected database function is this:

(1)transaction A is active. 
(2)transaction B attempts to get lock 
(3)but A is active, so B can not get lock 
(4)B have to wait seconds 
(5)A finish his work 
(6)B can finally get lock

if you use MySQL, it work like above.

But if you use SQLite, it DO NOT work like above.

This cause problem.



--------------------------------------
Power up the Internet with Yahoo! Toolbar.
http://pr.mail.yahoo.co.jp/toolbar/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to