I just did a quick load test on my little web app that is using SQLite
in C code. Pretty quick it ran into a SQLITE_LOCKED while a
connection/user was logging in to the site. I have some code that
responds to SQLITE_BUSY by sleeping for 50 mills and retrying 4 times:
int rc = FullLoginProcess(responseDTO);
while(rc == SQLITE_BUSY && retry < 4)
{
Sleep(50 * ++retry);
rc = FullLoginProcess(responseDTO);
}
Is it safe to handle the SQLITE_LOCKED the same way, aka simply make
the while look for either return code?
Sam
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
