Server updates

[thorsten.otto]

Yes, it's editable. At least i can enter text there, didn't try to send the changes.

[exxos]

The straw that broke the camel's back :lol:

Code: Select all

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in SpriteGrid.php on line 34

[exxos]

I have been doing some tests to decrease the store page load time.. I used USA as the client, and server is in the Netherlands.

Currently every image is loaded individually...Hence 224 requests.

n.PNG

Using css sprites ( several images were actually missing but at this point I really don't care) the requests drop to 69 and the page size increases dramatically.

css.PNG

Compressing the png css sprite file greatly reduced the file size, But load times was basically the same.

3.PNG

There will be of course a margin of error in tests, but reducing the connections definitely seems to help.

I'm not sure currently if I will go ahead with doing this anyway. It looks like the css sprites do not appear until the store page has actually been displayed :roll: But also, every item I add or remove items from my store I would have to rebuild the sprite file. Overall makes things more time-consuming to maintain rather than just dumping a individual image file over.

A plus point of using the sprites, is my store has to obtain image dimensions of every image because of some bizarre rendering bugs in firefox. Using the css does mean the dimensions are already worked out and stored so it would reduce server load fractionally in that respect.

EDIT:

The tables have turned now it seems.. I think what is happening is the large sprite file is not yet actually loaded when the store front is rendered. I found a extension for chrome to show page load times between the two methods, and now preloading the sprite image actually takes half a second longer!

So I think I'm just calling it now, but it really is not going to make any difference which method is used other than using sprites just makes things even more complicated.

[stephen_usher]

I guess the only other way to make things quicker is to restructure the site so that each category of item is on its own page with an index landing page pointing to the sub-pages.

[exxos]

I guess the only other way to make things quicker is to restructure the site so that each category of item is on its own page with an index landing page pointing to the sub-pages.

Ironically that is actually a feature of the current store where individual sections can be loaded. Looks like I totally forgot about it as it no longer works for some reason :roll:

[exxos]

ah, I see what's going on now.. In my SQL code, I put in a clause to only output a particular section if that section was only selected. This does actually work, and it does save a whole lot of hits on the SQL server. BUT, the problem is I need all the codes from the database to verify that people are actually trying to buy a valid item code. So it would actually remove "invalid" codes from your basket..

I will see if I can finish that coding off..

[exxos]

I'm going to see if I can get this system running on exxoshost as people not getting emails is becoming a huge problem now :roll: The updates were all done on the new server and updated forum software, so not sure how well or easy it will be to backport.

The updates are to allow forum users to view all their order history and tracking in your forum control panel. It's tested and working in the new server. Just wasn't intended to be rolled out on exxoshost.

I will try and have a look at it tomorrow. So if the server crashes everone know what's going on...

[Dan1975]

Just don't do a Facebook :lol:

[exxos]

Just don't do a Facebook :lol:

I already broke it yesterday, but nobody noticed did they ;) :hide:

A continuation is really this thread now... https://www.exxosforum.co.uk/forum/viewt ... =90&t=4690

[rubber_jonnie]

Just don't do a Facebook :lol:

I already broke it yesterday, but nobody noticed did they ;) :hide:

A continuation is really this thread now... https://www.exxosforum.co.uk/forum/viewt ... =90&t=4690

Errrm, afraid I noticed......

Couldn't get on for a few minutes, but then I couldn't contact you by PM or email as the site was down. Came back up pretty quickly.