Skip to main content
A
alucidgeeked
Participating Frequently
May 6, 2011
Question

coldfusion database queries slower on virtual ded server vs. shared host

  • May 6, 2011
  • 2 replies
  • 1739 views

I am working on moving my site from a shared host to a virtual dedicated server running Windows and IIS.  I have successfully installed Coldfusion on the new Virtual Ded server and everything is working perfectly, with the exception that queries on the new virtual server take a lot longer than those on the shared host.  This seems quite counter-intuitive to me.  I've tried playing around with settings in the CF Administrator, set my client storage from Registry to a database and several other things, nothing seems to help.  It's the same amount of data, same exact code, but the server that should be faster is quite a bit slower.  Anyone have any ideas?  I'm running Coldfusion 8 and a MySQL 5.0 database.

    This topic has been closed for replies.

    2 replies

    I
    iSaid
    Known Participant
    May 7, 2011

    How much RAM/CPU does your VDS package have?

    You will probably find that shared hosting servers have alot of ram/processing power compared to a VPS instance (at guarantee level) and also depending on the host, they may run seperate database servers and seperate CF servers too - each server tuned for their specific task.

    Don't forget your running Windows Server, IIS, CF and MySQL on the same server (and maybe other things too), so the more RAM the package has, I would say the better it would be.

    A
    alucidgeekedAuthor
    Participating Frequently
    May 7, 2011

    iSaid,

    Thank you.  I'm curious, since I'm relatively new to the virtual & dedicated server setups, would i be better off with two virtual dedicated servers, one running CF and one running the database, or would I be better off with one dedicated server?

    A
    alucidgeekedAuthor
    Participating Frequently
    May 7, 2011

    iSaid,

    Got to this before my coffee and completely forgot to answer your question.  I have a VPS from godaddy.com, here are the specs :

    1.87 Ghz

    • OS: Windows Server
    2008 Standard 64-bit
    • RAM: 3 GB
    • Storage: 45 GB‡‡
    • Bandwidth: 1,500 GB/mo

    Last night I removed all data that was older than 30 days and not necessary to store anymore.  Some seem to be a little slow still, but most of them have improved quite a bit, so I think my new standard will be to archive data to another table once a week if it is older than 30 days.  I'm also going through all my tables and double-checking my indexes.  Seems to be quite a bit improved since the archive, and its a small price to pay for the improved performance.

    ilssac
    ilssac
    Inspiring
    May 6, 2011

    alucidgeeked wrote:

    Anyone have any ideas?

    That there is a lot more to look at then just what is happening ON the new server.  What is happening BETWEEN the new server and the database server?

    A
    alucidgeekedAuthor
    Participating Frequently
    May 6, 2011

    The database server is new for the the new server, not using the old database server.  I have the datasource setup using "localhost" as the database server for the VD.  I have tried both maintaining client connections and turning that option off, doesn't seem to help at all.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices