Think of bandwidth as the volume of data returned by the web server to the browser, not machine cycles.
MySQL will use machine cycles, but there's more to it than that. For fastest response the fields you are running the query against should be indexed.
What pushes you to 20 queries per page? That seems a little excessive, as each of those is a hit to the database. Are the fields indexed? Are they cascading queries, the second depending on results returned by the first, the third upon the second, and so forth?
Could you handle your returned result set by getting more data and grouping it?
More information is needed to answer your question properly.
Regards - Miles Thompson
At 11:16 AM 3/11/2004 -0800, 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. -- Marcjon
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
