cfquery is much slower on virtual dedicated server vs. shared host

[lucidtech]

I am trying to move my site from a shared hosting account to a Virtual Dedicated server. Everything is working perfectly except that query response times are terrible on the new virtual dedicated server, which seems counter-intuitive to me. The servers are using two different database servers, but all the data is the same, indexes the same, etc. I have updated to the latest Java JDK and pointed Coldfusion to use the new Java, still no better. I've played around with maintaining database connections in the Coldfusion Datasource setup, doesn't seem to help either. Any one have any more ideas?

 

[lucidtech]

Used getTickCount, ran the same query with the same data on both servers.... the shared host gets a result of 150 or less ms. The new virtual dedicated server, over 300 ms everytime.

 

[lucidtech]

I also just ran the same query directly from the database server itself using Navicat.. got a query response time of 92 ms. Something with CF is definitely causing the problem.