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

meme

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.



None.

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.
[02:46 pm]
lil-Inferno -- pee pee child
[06:10 pm]
Ultraviolet -- sweet summer child
[2026-6-26. : 10:31 am]
NudeRaider -- blessed innocent soul knows nothing of the strife we had before EUDs were discovered :teehee:
[2026-6-23. : 3:29 am]
DarkenedFantasies -- Probably just didn't care. For example, at some point before release, they've updated the graphics of some of the Protoss buildings (Forge, CyberCore, Citadel, Observatory, Arbiter Tribunal), but instead of properly re-rendering them with edited 3D models, they did crappy copy-paste jobs on the rendered graphics.
[2026-6-22. : 8:35 pm]
Ultraviolet -- :wob:
[2026-6-21. : 11:38 pm]
Symmetry -- :wob:
[2026-6-21. : 4:56 am]
Ultraviolet -- I suppose we'll likely never know, but my guess would be that they already saw it operating successfully and there was no monetary incentive to finish the original work. And the dev cycle in old school Blizzard was so hectic, it's possible it just got forgotten about after the original game got released. Plus there's an element of existing MPQ files that were packaged with the original discs becoming outdated if they updated it. And it's not like they remade the original MPQs, they just made new ones for BW specifically
[2026-6-21. : 4:26 am]
Oh_Man -- so that makes me think maybe the theory they are unfinished is not true and its a deliberate design decision, coz why not finish them wen ur making brood war?
[2026-6-21. : 4:25 am]
Oh_Man -- the thing is thos buildings are from classic. that means they went ahead and made brood war without ever finishing the 'unfinished' buildings
[2026-6-20. : 6:15 pm]
Ultraviolet -- Yeah he's talked about a lot of that stuff in his casts before. It seems plausible. Especially knowing how Blizzard of yesteryear operated.
Please log in to shout.


Members Online: O)FaRTy1billion[MM]