Sorry it took me so long to reply, was trying several things, including switching my database back to the old server.
First, I disabled IIS and installed apache, got CF working with apache, tested results, saw very little improvement, if any at all.
Uninstalled apache, went back to IIS, got everyting back up. Changed the database to use the shared host database, some improvement, but it still doesn't run nearly as fast as the shared host does. In fact I can click the a link on both sites one right after the other, even if i click the new VPS server first, the shared host site always loads at least 3 seconds faster.
The site works great when queries are incredibly small, but anything that has to pour through any length of data in the database and the system hangs, sometimes it seems forever. My cfoutput tags are timing out on the new server when I get any sort of traffic on it (even 5 members logged in at once) but I can have 100+ members on the shared host with no issues whatsoever.. it still runs faster than the VPS server does with just me on it.
I double checked all my indexes, everything seems to be in order and matches the shared host db exactly. The only difference I can see between the two servers, other than one being a virtual dedicated and the other being shared, is that the shared host uses apache instead of IIS. But again, I already tried that. Also, should be noted that the shared hosts database has every line of data ever written on the server still in its tables, the virtual dediated host has only a fraction of that since I removed anything that was older than 30 days an no longer necessary.
As far as server monitor, it's yelling at me telling me that queries are taking way too long... I already know this. I have used mysql console and run these queries using EXPLAIN, saw no issues, server returns the results and explanation incredibly fast. It's got to be something with the way MySQL is being handled by Coldfusion, but I've played around with every setting I can think of to no avial (I have reprovisioned the server since getting desperate and just clicking boxes in the CFAdmin in the hopes I'd figure something out). This has been weeks of my life trying to get this setup, and everything is so perfect with the exception of these query times... I even have SmartFox2X setup, running and ready for me play around with (for the record, I ran tests before the SmartFox installation, the connection between Coldfusion and MySQL was the same slow speed).
At this point my guess would be one of two things.
The virtual dedicated host can't handle the amount of traffic that the shared host can, either in database queries simultaneous users, which seems incredibly unlikely. As fast as this site runs on my local server, which is a laptop, I would have expected my site to be screaming fast on this new server.
Or, Coldfusion isn't setup right. It's an out-of-the-box Coldfusion8 installation with a web service configured for all IIS sites. I added my datasources, made sure debuggging was disabled, etc. Haven't changed much outside of that except for disabling Client variables (thought this could be the issues, since they were being stored in registry with the out-of-box installation and I've heard that is def not a good thing).
I'd be more than willing to temporarily change my Coldfusion Admin password and give you access to it iSaid if you wanted to take a look around. Nothing makes sense to me... the Coldfusion I have on my laptop is out-of-the-box as well and my laptop handles load better than this server does.
Sorry about how long-winded this is, but I am beyond desperate. This site is my only source of income and I have put the last year of my life (seriously working 60+ hour weeks since it launched, and loved every minute of it) and I hate to see it die because I cannot get this stupid server set up right. I need help... I'm actually way past needing help.
9
Replies
AdChoices