Hi All,

I have just implemented some code as per this thread to show the page loading time at the bottom of each page, and am finding (as I suspected) that my loading times are a bit slow at around 1.3 seconds to load my main page. This is about 1 second slower than what I'd consider a decent average time.

I think this is attributable to two main reasons;
(a) My hardware is getting a bit old
(b) My site runs too many queries on site entry

I ran the MySQL/Blocks dubugging mode, and I found that upon entry to my site the server runs 77 queries, 23 blocks in about 1.3 seconds. Short of removing content, or upgrading my hardware I have no idea if there are any other methods to reduce this time.

Anyway, I was just curious as to what infrastructure other Xoopers used to serve their XOOPS sites, and if possible a few other details such as I've provided below. Mine is as follows;


Hardware & Internet Connection Environment

PIII 550Mhz
1024MB PC-133 SDRAM
10GB ATA-66 5400RPM HDD

512k/512k SDSL Connection


Software & XOOPS Environment

Windows 2000 Adv Server
IIS 5
Xoops 2.0.4
MySQL 4.0.13
PHP 4.3.2

Total queries run upon site entry = 77
Total blocks on site entry = 23
Approximate average time taken = 1.3 seconds

Quote:

You could try the cache settings for the blocks that don't need to be queried from the DB every time a user visites the page. This can reduce the number of queries a lot, thus saving you on the load time.

Herko

Yeah I tried that, but it still seems to run the same anount of queries

Thanks for the suggestion though. Perhaps I could try using a MySQL DB optimiser to get a bit of speed?