Staredit Network > Forums > Staredit Network > Topic: Updates 2017-05-10
Updates 2017-05-10
May 10 2017, 11:23 pm
By: Moose  

May 10 2017, 11:23 pm Moose Post #1

Armor: 100%

The AJAX request to get the users in the shoutbox (on the shoutbox main page) was optimized. As in yesterday's updates, there is still a lot of unoptimized code killing performance.

Given the optimizations of the past few days, the requests to the site in roughly the previous 24 hours of uptime have been:
Shoutbox Refresh: 44.90%
Notifications: 12.32%
Users Online: 7.93%
Users In Shoutbox: 13.36%

Technical details:
- Users in shoutbox now has its own table, similar to the users online table.
- Users in shoutbox is no longer a query on the enormous sessions table joined with the users table.
- Users in shoutbox query now only selects needed columns instead of *.

Post has been edited 1 time(s), last time on May 10 2017, 11:38 pm 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