Yeah, the site is noticably quicker. Too bad Natter just got killed, or we could really stress-test it.
Inara: Mal, this isn't the ancient sea. You don't have to go down with your ship. Mal: She ain't going down. She ain't going anywhere.
'Out Of Gas'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Gris - Aug 24, 2004 12:00:20 pm PDT #8151 of 10000
Hey. New board.
§ ita § - Aug 24, 2004 12:48:53 pm PDT #8152 of 10000
Well not canonically, no, but this is transformative fiction.
I ran quick stats on the test site, and the main query that populates both the main page and the message centre now runs 80% faster.
More improvements as I think of them.
§ ita § - Aug 24, 2004 2:47:44 pm PDT #8153 of 10000
Well not canonically, no, but this is transformative fiction.
Right now, the threads are broken into three groups -- default (centre panel), admin, and tools/archives.
What is thought of the idea of adding a fourth group -- closed. This could clear up the main panel if threads are moved automatically on closing, and I think it would make a couple pages faster. There could be a separate page for closed threads. Which would still be in the read new rotation.
Or would that make things too confusing?
Liese S. - Aug 24, 2004 3:16:15 pm PDT #8154 of 10000
"Faded like the lilac, he thought."
Does there have to be a separate page in order to gain the benefits of it? Or can it just sit at the bottom, aesthetically the same?
§ ita § - Aug 24, 2004 3:18:53 pm PDT #8155 of 10000
Well not canonically, no, but this is transformative fiction.
If they're displayed on the page, there is no gain.
Liese S. - Aug 24, 2004 3:30:50 pm PDT #8156 of 10000
"Faded like the lilac, he thought."
In that case, I vote for new page and gain. And also, do we have policy for how long closed threads stay up before archival, or is it just until DX gets to do his thread-editing mojo?
§ ita § - Aug 24, 2004 4:11:40 pm PDT #8157 of 10000
Well not canonically, no, but this is transformative fiction.
There are two things that need to happen -- DX does his mojo, and I do some too. Except my mojo doesn't work with this version of MySQL, so there hasn't been any done since we moved in.
Betsy HP - Aug 25, 2004 4:45:15 pm PDT #8158 of 10000
If I only had a brain...
main query that populates both the main page and the message centre now runs 80% faster.
Who is a star? ita is a frellin' supernova. Yeaaaa!
§ ita § - Aug 25, 2004 4:50:10 pm PDT #8159 of 10000
Well not canonically, no, but this is transformative fiction.
Heh.
If anyone feels like applying themselves to further SQL optimisations, please submit resumes.
I asked istrata support about why we're so far behind in versions from the rest of the world. It's a Plesk (our control panel) issue. If I had SSH access from work, I'd not be so leery about breaking Plesk -- as it, it's the only way I can get in to do a lot of stuff, a lot of the time. Here's the support answer:
These packages were provided by RedHat in 7.3 which as you know is end of lifed. Updates that are available from the Fedora Legacy Project are security fixes only, no new versions of software will be introduced. That said you can safely upgrade MySQL to my knowledge (but do so at your own risk :-), but upgrading PHP, at least with the standard PHP RPMs will break Plesk. There is a guy on the Plesk Forums (Something like Atomic Monkey) that is building his own Plesk friendly RPMs but they are not supported so proceed cautiously if you decide to use them. The best solution I have is Plesk 7 which was recently released (you're running version 5). Plesk 7 includes an upgrade of PHP to 4.3.8 among many other enhancements (Application Vault, Spam Assassin, new skins, and lots of other cool features.). I can upgrade your Plesk installation to the latest version for $99.
Liese S. - Aug 25, 2004 4:58:20 pm PDT #8160 of 10000
"Faded like the lilac, he thought."
Huh. Yeah, it's no fun to break the control panel.
I reckon we could at least upgrade to the point that we're able to. But it looks like we'll need to deal with it at some point in the future, huh? Anyway, do we know if upgrading MySQL will help our Big Problem? Because that would be good, and worth doing, if cautiously, if so.