Hey Rob,
Thanks for replying.

> It's usually a sign of poor programming and/or
> purist OOP programming.
> 
> When I say purist OOP programming...
> I saw
> one really retarded
> implementation of this kind of system where an
> excess of 20000 queries
> were issued to the database -- on a homepage
> nonetheless :/ 


That IS retarded, I wonder why someone would want to
do that.


> I think it
> was a testament to MySQLs speed that it performed
> within a reasonable
> timeframe (under 3 seconds). 

MySql is a workhorse... def one of my top 3 DBs (I
came into LAMP from Java/Oracle)

I see you have seen some of the apps I was talking
about, even though I have not mentioned any names to
offend anyone.

I was curious about this because I am working on a
project (with other team players) and we have a way of
building something with either lots more (complicated)
code and fewer database calls or less code and
multiple tables.

If we take the second option (multiple tables) I am
talking about maybe 15 database calls per page, and
the site will get around (i guess) 300-750 requests
for a page a minute at is peak.

The good thing is it will be running on a dedicated
server, sharing with around 5 of our other sites... no
exceptionally great traffic other than mentioned above
on the other sites either, plus most of the other
sites are plain html sites.


> > Or am I blowing smoke and MySql can handle that
> > without a sweat on a shared hosting environment?
> (with
> > say....100 page requests per minute?)
> 
> MySQL can probably handle it. But try not to do
> programming like that yourself. Stuff like that
gives PHP a bad name.


I wouldnt be going to those extremes, was thinking of
around 5-15 queries per page.



Think we'll have a problem?

Thanks!
Ryan

------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to