Server updates

Latest Atari related news.
User avatar
thorsten.otto
Posts: 148
Joined: Mon Nov 04, 2019 2:20 am

Re: Server updates

Post by thorsten.otto »

Yes, it's editable. At least i can enter text there, didn't try to send the changes.
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by 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
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by 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
n.PNG (54.97 KiB) Viewed 4961 times

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
css.PNG (75.49 KiB) Viewed 4961 times

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

3.PNG
3.PNG (76.23 KiB) Viewed 4961 times

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.
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
User avatar
stephen_usher
Posts: 5578
Joined: Mon Nov 13, 2017 7:19 pm
Location: Oxford, UK.
Contact:

Re: Server updates

Post by 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.
Intro retro computers since before they were retro...
ZX81->Spectrum->Memotech MTX->Sinclair QL->520STM->BBC Micro->TT030->PCs & Sun Workstations.
Added code to the MiNT kernel (still there the last time I checked) + put together MiNTOS.
Collection now with added Macs, Amigas, Suns and Acorns.
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by exxos »

stephen_usher wrote: Mon May 31, 2021 12:39 pm 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:
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by 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..
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by 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...
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Dan1975
Posts: 53
Joined: Fri May 01, 2020 6:08 pm

Re: Server updates

Post by Dan1975 »

Just don't do a Facebook :lol:
User avatar
exxos
Site Admin
Site Admin
Posts: 23488
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Server updates

Post by exxos »

Dan1975 wrote: Tue Oct 05, 2021 12:36 pm 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
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
User avatar
rubber_jonnie
Site Admin
Site Admin
Posts: 10462
Joined: Thu Aug 17, 2017 7:40 pm
Location: Essex
Contact:

Re: Server updates

Post by rubber_jonnie »

exxos wrote: Tue Oct 05, 2021 12:42 pm
Dan1975 wrote: Tue Oct 05, 2021 12:36 pm 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.
Collector of many retro things!
800XL and 65XE both with Ultimate1MB,VBXL/XE & PokeyMax, SIDE3, SDrive Max, 2x 1010 cassette, 2x 1050 one with Happy mod, 3x 2600 Jr, 7800 and Lynx II
Approx 20 STs, including a 520 STM, 520 STFMs, 3x Mega ST, MSTE & 2x 32 Mhz boosted STEs
Plus the rest, totalling around 50 machines including a QL, 3x BBC Model B, Electron, Spectrums, ZX81 etc...
Post Reply

Return to “NEWS & ANNOUNCEMENTS”