- Joined
- Jun 18, 2002
- Messages
- 28,358
A very small minority (almost inconsequential really) may have noticed a few things lately:
As the Codex is run entirely on its forums (the news & content systems are linked into it) it takes a bit of time to re-code everything (and also because I'm coding in cool new stuff that we desperately needed a few years ago). This is just a matter of me spending less time in Minecraft and more time in PSPad during my spare time (though it pretty much works now - pending the game databases we don't really use anyway).
The major problem now however, is that the raw Codex database is over 2 GB in size. Certain issues arise when you're dealing with that much data - mainly that all the converters I rely on to convert our phpBB2 forum to the new software take a long time to process all the data (think days) and they're failing about 1/10th of the way through. That's an issue with PHP not being a great tool to run converters through but the only other alternative is I run some SQL commands straight through the command line. To do that means I need to spend a lot of time building them.
I'm currently trying to avoid that by digging into the errors, trying to fix them, playing with settings and trying the conversion again, then rinse and repeat. Taluntain is also looking at paying a mob to do it for us to see if that works.
Left to do now are:
¹No, literally. If we don't fix this by the end of the year we'll probably have to go offline every other day. As it is Taluntain has to knock the Codex off every now and then in order to let things settle.
- Server 500 Errors
- Having to login multiple times per day - even when you tick the "keep me logged in" box.
- Shit being as slow as fuck.
- Other shit generally not working.
- Search for text in post through MySQL full text search (currently disabled - redirects to google instead)
- The query that loads the list of threads when you look at a forum.
- The query that loads all the data in a given thread.
As the Codex is run entirely on its forums (the news & content systems are linked into it) it takes a bit of time to re-code everything (and also because I'm coding in cool new stuff that we desperately needed a few years ago). This is just a matter of me spending less time in Minecraft and more time in PSPad during my spare time (though it pretty much works now - pending the game databases we don't really use anyway).
The major problem now however, is that the raw Codex database is over 2 GB in size. Certain issues arise when you're dealing with that much data - mainly that all the converters I rely on to convert our phpBB2 forum to the new software take a long time to process all the data (think days) and they're failing about 1/10th of the way through. That's an issue with PHP not being a great tool to run converters through but the only other alternative is I run some SQL commands straight through the command line. To do that means I need to spend a lot of time building them.
I'm currently trying to avoid that by digging into the errors, trying to fix them, playing with settings and trying the conversion again, then rinse and repeat. Taluntain is also looking at paying a mob to do it for us to see if that works.
Left to do now are:
- Convert phpBB2 to our new forums.
- Check that my code actually works with all that data.
- Update!
- Hope shit works (if it doesn't, resort to Plan B).
¹No, literally. If we don't fix this by the end of the year we'll probably have to go offline every other day. As it is Taluntain has to knock the Codex off every now and then in order to let things settle.