views:

7

answers:

0

Hi all,

I develop web applications and I always used client/server databases (like MySQL) to store the application data. I would switch to an integrated DB engine like SQLite.

I have a question. What happens if I have for example 1000 users visiting the web site and typing text in a textbox with suggestions (lots of request to the server)? I mean, the file should be locked during every request, right? So what if I have lots of concurrent request to the file? I'm not talking about performance, I'm talking about having an error like 'Impossible to open the file: the file is locked'. I tried to read around but I couldn'd address this problem.

Thanks. Luca