Re: Impact of MySQL Queries

[Cal Evans <cal@xxxxxxxxxxxx>]

If both services are running on the same machine then no, the number of 
queries per page will not affect bandwidth. It will however, affect you 
processor usage. Without having seen your code, I can only make 
generalizations. 20 queries is a bit excessive but it's still manageable 
if the server is not being hit too heavy. To answer your question 
directly, yes, it will start to slow down as you have more people using 
the system.

I would suggest you consider the following.

1: Use ADODB as your abstraction layer.  It has built in query caching 
and could dramatically improve page speed as well as lower processor usage.

2: Take a hard look at your code and make sure you actually need 20 
queries on a page. Would a single query be possible and then spin 
through the result set?

3: Consider moving to a Linux box. (Sorry, had to be said) Without the 
overhead of a GUI, your processor will be more available for mysql and 
your web server.

4: Make sure you have the proper indexes set. If you do need 20 queries, 
20 fast queries are better than 20 slow queries.  :)

HTH.

Let me know how I may be of service,
=C=
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take care of your business.
*
* I think inside the sphere.


Marcjon Louwersheimer wrote:
> I have IIS 4.x and MySQL running on the same machine. So do queries use
> up bandwidth? Does it matter if I have 20 queries per page? Will that
> slow it down if many people started using my site? Currently only I, and
> some friends for testing, use it.

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