MySQL Connections....

[pambo]

Hi, 

 

I have never worried about the number of simultaneous connections to a MySQL database before, as the sites I have made so far weren't targeted for very many simultaneous users. However, I am dealing with a site now, whereby potentially thousands of users might be on at once. The application I need is very specific - i need to count the time that each user has been on the site and store it in the database.  Is this possible? What happens when too many users are connecting to the database at once??   

 

Thanks in advance for any insight to this!! 

 

Pambo   

[jackpf]

What happens when too many users are connecting to the database at once??

Well...it'll probably overload.

 

If you are that conserned about database usage, you could use SQLite for this particular function, rather than your mysql database, or your main database, whatever that may be.

 

SQLite is pretty fast and able to cope with a lot of connections. May be a better option.