Paul,
Just because GForum had 127 queries does *NOT* make it good practice. 127 queries puts a huge load on a program like MySQL - a busy forum could potentially have a few simultaneous people load the main page. Imagine MySQL getting 400 queries all of a sudden, even if they are simple queries the sheer number is going to cause problems.
You should aim to minimise the total ammount of SQL queries per page to reduce load and produce fast pages. I was talking in another thread somewhere about each query adding up - and optimising code etc and how one 10th of a second etc does make a difference. Think about having that ammount of queries, plus loading up all the code, plus processing all the code etc - it is going to be quite slow.
Cheers,
Michael Bray
Just because GForum had 127 queries does *NOT* make it good practice. 127 queries puts a huge load on a program like MySQL - a busy forum could potentially have a few simultaneous people load the main page. Imagine MySQL getting 400 queries all of a sudden, even if they are simple queries the sheer number is going to cause problems.
You should aim to minimise the total ammount of SQL queries per page to reduce load and produce fast pages. I was talking in another thread somewhere about each query adding up - and optimising code etc and how one 10th of a second etc does make a difference. Think about having that ammount of queries, plus loading up all the code, plus processing all the code etc - it is going to be quite slow.
Cheers,
Michael Bray