Staredit Network > Forums > Staredit Network > Topic: Updates 2017-05-08
Updates 2017-05-08
May 9 2017, 12:56 am
By: Moose  

May 9 2017, 12:56 am Moose Post #1

Armor: 100%

The shoutbox code and database table were updated to increase performance. Regarding general slowness, there is still a lot of unoptimized code killing performance. However, the shoutbox is loaded on every page and makes frequent queries, so it made for some good optimization.

Technical details:
- In the shoutbox table, changed columns of type int that only ever used two values to bit type and updated queries accordingly.
- Created a more effective concatenated index used by shoutbox queries.
- Changed queries on the shoutbox table that ordered by time (which wasn't indexed for some reason) to use the primary key instead, since the id and time are monotonically increasing.

EDIT: To give credit where it's due, shout out to Ashamed for some advice and motivation.

EDIT 2: For a sense of scale, on a four-hour uptime, shoutbox refresh requests made up just over 27.99% of requests to the site according to the access logs.

Post has been edited 3 time(s), last time on May 10 2017, 2:36 am by Mini Moose 2707.




Options
  Back to forum
Please log in to reply to this topic or to report it.
Members in this topic: None.
[2026-11-21. : 7:14 pm]
Symmetry -- so it shows the version history of temple siege
[2026-11-21. : 7:13 pm]
Symmetry -- I think he's trying to find the most popular versions of maps
[2026-11-21. : 9:24 am]
UndeadStar -- yes it helped...but I didn't understand what the picture was about lol
[2026-11-21. : 6:10 am]
NudeRaider -- UndeadStar
UndeadStar shouted: I somehow don't dare to look at an image without explanation from someone called Decency. Reverse psychology maybe?
does it help your fear when I tell you he used to call himself FaZ-?
[2026-11-20. : 5:02 pm]
UndeadStar -- I somehow don't dare to look at an image without explanation from someone called Decency. Reverse psychology maybe?
[2026-11-19. : 10:19 pm]
Decency -- https://i.imgur.com/DMFELQd.png
[2026-11-19. : 9:16 pm]
ihjel -- No bots online :omfg:
[2026-11-19. : 8:15 pm]
Moose -- o, I thought it was EUD, gg
[2026-11-19. : 3:58 am]
Symmetry -- Reindeer breeding 2 is not EUD and errors when I try to upload
[2026-11-19. : 12:26 am]
Moose -- Symmetry
Symmetry shouted: yeah uploading for me has been a 50/50 toss up here lately
certain EUD maps segfault the map parser, :farty: ignore me the last time I complain at him. :crybaby:
Please log in to shout.


Members Online: Decency, Rawflesh0615