On Thu, 2006-03-30 at 19:31, Philip Hallstrom wrote: > > I have almost finished making a set of scripts that would communicate with > > maybe 1k sites to start with... > > > > I'm sorry I cannot give you more details about the scripts but this guy is > > really nervious and had me sign an NDA etc etc > > > > but what i would like to know is; would there be a problem with connecting > > to the database many hundred/thousand times a minute? (esp on a shared > > server as this guy and I cannot afford a dedicated at this point) > > Mostly the "normal/usual" queries...eg: select, update, delete very little > > JOIN or sub-selects > > There's no problem doing that... 1,000 times a minute is only 16 queries a > second. Ummm, he said connecting, not querying. Remote sites often take more than a second to establish a connection. Good luck. And if I was the host, I'd have limits slammed on you the same day (if not already) *lol*. Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php