Increased Speed and Reduced Server Load

[RWAP]

This was previously one of our free modules for the Enuuk auction platform.

However, we have had to undertake further work and enhancements to the package as supplied in order to not only further increase speed, but also to reduce the load on your website server - this is essential where a shared server is used for hosting.

Speed increases are substantial over the original code through removing repeated processes where the whole of the offer database is looped through.

We have also reduced the server load by looking at how the data is generated for JSON and RSS feeds within the Enuuk platform.

Cost £150
Available from: http://www.rwapservices.co.uk/enuuk_modules.html

[RWAP]

We have now made further improvements to this module, by moving the JSON and RSS handling into separate files, which has effectively increased the speed of all JSON and RSS feeds, whilst also reducing the file size for some of the main classes in the site (such as Category.php and Index.php) which has improved their speed.

We have also created our own calls to produce the list of auctions for RSS and JSON feeds, rather than fetching lots of extraneous data not used by these feeds!

[RWAP]

We have also made a further improvement to this, by setting up a lazy loader for accessing item->images

These are rarely used, so it seems odd to get the information on them all the time from the server when accessing lists of items (these are the gallery images only).

[RWAP]

We have now found some further speed savings, with a re-written userAccess class and improvements to the store class (these were impacting quite substantially on sites with 1000+ active listings).

[RWAP]

In fact, we kept finding extra things which could be done to improve the Store class, and have pretty much now re-written the code to improve speed quite considerably (as the Store class is used extensively across Enuuk sites).

[RWAP]

Having re-written the Store class, there is now not much server load when just viewing the categories and home page for example.

[RWAP]

Managed to find a massive extra speed enhancement - ideal for reducing the load when you have 3000+ listings on a website.

Following a reworking of how the userAccess class is used, we have reduced the browse category page (with 3000 listings) from around 11 seconds to 2 seconds !!

Further speed enhancements achieved this week, include re-writing the code which decides which items you need to leave feedback for.

[RWAP]

Yet another minor improvement achieved this week - with a re-write of teh getOfferCount routine, which was having a major impact the more listings there were on the site.

[RWAP]

It's amazing when you look at some of the Enuuk code how small changes can be made which help to improve performance.

I have just spotted a few changes in the past few days, basically using the GROUP by command to reduce the amount of data being fetched from the database in getUserSells(), getOffersWonBy() and getUserBuyers() functions

Another change we have instigated is to prevent lots of users all requesting data from the server at the same time. Basically if a user is looking at the homepage, a listing page, a store or a category page when a listing ends, the countdown() code refreshes the page. Now if many users are viewing a page on which that listing appears, they all suddently call on the server to refresh the page for them.

What we have done is to simply change the code in global.js to add a random delay of up to 3 seconds when a countdown finishes, before asking to refresh the page.

Does anyone think this might be an issue?

[RWAP]

We have released v2.04 of this module now.

Whilst this is an interim release, v2.04 offers further speed improvements for user feedback, sold and won items, which are essential when you have sold over 4000+ items through the Enuuk platform!

v3.00 will soon be released, and this incorporates our new SQL cache for dramatically reducing the amount of calls to the SQL server, thus releasing quite a few server resources as well as making a noticeable improvement in response times.