Staredit Network > Forums > Staredit Network > Topic: Updates 2017-05-09
Updates 2017-05-09
May 9 2017, 11:33 pm
By: Moose  

May 9 2017, 11:33 pm Moose Post #1

Armor: 100%

The notifications AJAX code and database table were updated to increase performance. As in yesterday's updates, there is still a lot of unoptimized code killing performance. However, notifications are requested through frequent queries on every page, so it made for some good optimization. For a sense of scale, AJAX requests about notifications were about 14.2% of the requests for the site in the past hour.

Technical details:
- In the notifications table, changed column of type int that only ever used values of 0 and 1 to bit type. Updated queries accordingly.
- Created a more effective concatenated index for notifications queries.

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




May 10 2017, 7:29 pm O)FaRTy1billion[MM] Post #2

👻 👾 👽 💪

:moose:



TinyMap2 - Latest in map compression! ( 7/09/14 - New build! )
EUD Action Enabler - Lightweight EUD/EPD support! (ChaosLauncher/MPQDraft support!)
EUDDB - topic - Help out by adding your EUDs! Or Submit reference files in the References tab!
MapSketch - New image->map generator!
EUDTrig - topic - Quickly and easily convert offsets to EUDs! (extended players supported)
SC2 Map Texture Mask Importer/Exporter - Edit texture placement in an image editor!
\:farty\: This page has been viewed [img]http://farty1billion.dyndns.org/Clicky.php?img.gif[/img] times!

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