I've just worked out what version number each update should be known by based on the size of the update (increases by 0.1 for big updates or 0.0.1 for smaller add-ons/bug fixes) and am proud to announce that this support forum is now running v1.5 of our software

Unfortunately v1.5 does not have any great new features but it does have the basis of a great caching system. The idea of a caching system is to store some generated source code and keep reusing it until it needs to be changed. This cuts down on the number of times the database needs to be queried so should improve performance.

I've set this forum to use the updated source code so that it'll be easier to monitor and adjust this new system in order to give the best possible performance. This should also enable us to find any bugs still in the system nice and early and perhaps identify other areas in need of some optimization.

The areas that are running the new system to various degrees include mini-profiles, the last post column on the main page and topic replies. The data shown in the footer of every page should give you some indication to how well the system is working.

If you continue to get high numbers of database queries on any page then please let me know so I can look at improving that page. Also let me know if any pages are giving peak memory usage of over 1500Kb, current memory usage of over 1000Kb or a loading time of over 1 second. Not all pages which give these will be rectifiable but I will do my best to give the best possible performance so that you can use the fastest possible forums.

- Ross

It's all looking good so far, not really getting close to the max useage

Though there's no new features it's still a good update, and gives better running times

Whee!

Wait I actually joined something before version two? o_o

847 = peak
684 = current
31 = queries
5 = cache
0.517 = seconds

Weee any more info people want to know?

it Ross

All my pages refresh with 0.000 load o_O. Then again I get roughly 27,000 kilibytes per second.

For viewing this thread:

This page was generated with 30 database queries and 7 cache files in 0.0001 seconds.
Peak Memory Usage: 848Kb :: Current Memory Usage: 688Kb

On my 10 year old school computer it runs as follows:

This page was generated with 32 database queries and 7 cache files in 0.2802 seconds.
Peak Memory Usage: 858Kb :: Current Memory Usage: 694Kb

Sexy work, Ross.

Very speedy Ross, great work mate

This page was generated with 32 database queries and 7 cache files in 0.7933 seconds.
Peak Memory Usage: 869Kb :: Current Memory Usage: 696Kb

This page was generated with 29 database queries and 8 cache files in 1.107 seconds.
Peak Memory Usage: 888Kb :: Current Memory Usage: 705Kb

This page was generated with 29 database queries and 10 cache files in 0.2942 seconds.
Peak Memory Usage: 903Kb :: Current Memory Usage: 711Kb

Really nice

it seems a bit faster, im on my new psp so the thread parts are showing a bit different then the pc view. But I like this psp. It is the old psp. ^_^

This page was generated with 32 database queries and 12 cache files in 0.5782 seconds.
Peak Memory Usage: 943Kb :: Current Memory Usage: 726Kb

Wow Ross, looking nice. The queries seem to hover around 30 queries.

This page was generated with 32 database queries and 14 cache files in 0.2163 seconds.
Peak Memory Usage: 987Kb :: Current Memory Usage: 736Kb

This page was generated with 34 database queries and 14 cache files in 0.4018 seconds.
Peak Memory Usage: 1014Kb :: Current Memory Usage: 754Kb

Come on Ross. I know you can use less queries. Link them or something. It'd help a lot. Especially the 81 on the main page.

Posted By Chris on 20th Jan 08 at 6:22pm

 

This page was generated with 34 database queries and 14 cache files in 0.4018 seconds.
Peak Memory Usage: 1014Kb :: Current Memory Usage: 754Kb

Come on Ross. I know you can use less queries. Link them or something. It'd help a lot. Especially the 81 on the main page.

The main page hasn't been properly optimised yet, especially not the board access queries. I'll be doing them some time next week (if I'm feeling better) which should cut a bit off of there. The biggest abuser of queries on the main page is on forums with lots of different users moderating/having the last post but nothing can be done about that without greatly increasing the memory usage. And unfortunately there's about 18 queries which make up the core of the system and which can't be cut down without either losing features or increasing the loading times on other pages.

Since I am on my computer now, this is what it shows.

Main Page:
This page was generated with 79 database queries and 0 cache files in 1.6894 seconds.
Peak Memory Usage: 907Kb :: Current Memory Usage: 745Kb

This Page:
this page was generated with 37 database queries and 16 cache files in 0.436 seconds.
Peak Memory Usage: 1073Kb :: Current Memory Usage: 773Kb

The main page has now been optimised and is using (on average) 35-40 less queries. I've not yet uploaded those changes to this server though.

Well, can't you store a copy of the settings? That would surely save (a bit) of time. (Well, depending how it's set up.) Also, maybe only check for PM updates ever 5 seconds or something? A user doesn't need to know right away. There's a few different techniques that can be done. Those are just a few suggestions.

Posted By Chris on 22nd Jan 08 at 12:52am

 

Well, can't you store a copy of the settings? That would surely save (a bit) of time. (Well, depending how it's set up.) Also, maybe only check for PM updates ever 5 seconds or something? A user doesn't need to know right away. There's a few different techniques that can be done. Those are just a few suggestions.

I've removed 2 queries from the main setup. The ban list is now only updated once every 15 minutes and the users online is only updated when the info center displays.

Saving the settings info in a cache file would use more memory that it'd save since it is updated so often. However as I type this I've thought of another way to cut 1 more query off of the main page and another 2 off of the info center.

Posted By Ross on 22nd Jan 08 at 9:46am

 

Posted By Chris on 22nd Jan 08 at 12:52am

 

Well, can't you store a copy of the settings? That would surely save (a bit) of time. (Well, depending how it's set up.) Also, maybe only check for PM updates ever 5 seconds or something? A user doesn't need to know right away. There's a few different techniques that can be done. Those are just a few suggestions.

I've removed 2 queries from the main setup. The ban list is now only updated once every 15 minutes and the users online is only updated when the info center displays.

Saving the settings info in a cache file would use more memory that it'd save since it is updated so often. However as I type this I've thought of another way to cut 1 more query off of the main page and another 2 off of the info center.

See? I can be helpful. As I said, I don't know the layout of your system, so I can't really give suggestions.

This forum is now running on the latest version of the source code. All areas that I was aware of using a large number of resources have now been fixed. I will leave this version just on here for a couple of days to ensure the caching of birthdays and events are working and so long as no other bugs are found all forums should be upgraded on friday

Ross, seriously, is there anything you can't do?

Posted By (¯`•Stormraven•._) on 26th Jan 08 at 6:26pm

 

Ross, seriously, is there anything you can't do?

Fly?

*Sees Ross float past bedroom window*

Ross has been in your room . Didn't know he was that sort of person

Posted By (¯`•Stormraven•._) on 26th Jan 08 at 6:43pm

 

Ross has been in your room . Didn't know he was that sort of person

Shh.