Forum: Community Center


Subject: Why is the site sooooo sloooowwwwwww

pendarian opened this issue on Apr 22, 2002 ยท 28 posts


ShadowWind posted Mon, 22 April 2002 at 2:33 PM

While I'm the first one to admit that the internet health has to do with the speed of any web site, this site is running like a mouse stuck on a glue trap. Okay, bad imagery, but the point is that their servers seem to be busting at the seams, specifically the mySQL one. I'm not surprised that the server upgrade didn't help that much if at all. mySQL, despite the speed of the server, is a free program by the open source project and is fairly stable if properly configured, BUT it has a bottleneck in the amount of write versus read requests it can handle at any one time without getting all choked up.

To fix this site, it seems to me they have to rethink their whole database strategy. If they insist on using mySQL, they need to be aware of it's shortcomings and find ways to work around them. We use mySQL at work and have fairly high volume, but we don't rely on just the mySQL daemon for all requests and processing because we know it's a dog. If database handling is the only option, then Bondware needs to consider opening up it's wallet, getting Oracle and an administrator to keep an eye on it (it's kinda finicky) and go from there. Oracle, while not the most stable, does handle high end traffic situations such as this, as does other packages like SyBase, etc...

So the question is when is Renderosity going to make an effort to replace their current SQL system? I realize they may be out a programmer at the moment, but still, this is something they need to address with more than a bandaid for as Richabri said, it is still unacceptably slow...

My 2c as an internet developer...