Hey all, Ok, spoke to the "boss" and he has agreed for me to give you the following info;
Heres what the app does: - Clients add their sites in their "client control panel" which we give them at our site - Client installs our script on his server, every time someone logs in their username is sent to us along with their IP and "other details" (cant reveal due to NDA but unimportant in this emails context) - we take the username and query the db to see if this username already exists and what parameters this username has set -- we update the database for statistics -- we update this usernames parameters -- again run SQL statements 1-3 times (Other processing happens between the above points of course but not related to the database so I didn't write them and some points couldn't write due to the NDA - my apologies once again) NOTE: The above is for _one_ username and _one site_ ..... eventually there will be hundreds of sites and each site will have X number of usernames which will be sent to us for processing. If this project goes well and once we can afford it this will be moved to a dedicated box but till then... do you guys foresee any problems with PHP->database->PHP Running Chris' SQL: show status like '%connection%'; gave me these results: Connections 49029 Max_used_connections 109 I was also looking at mysql_pconnect() and reading up about it at php.net, most of the comments say to actually avoid it, but reading what i wrote on top.... what do you say? any alternate suggestions as usual are most welcome too. Right now I'm using the normal mysql_connect() We are using just one mysql database with around 7 tables - trying to keep this as simple as possible Thanks, Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
