Chip, As Jordan pointed out much of the stuff to check will be up to your NOC support guys. Here's things that come to the top of my head.
Sometimes hosts use virtual network to isolate your "system" from other systems in the same data center or on the same rack. In that case the connection is going through VPN protocols which can incur overhead. In addition, DNS comes into play if you are using a FQDN (your machine has to look it up). Note: If you use an IP address your stack will actually look up the Reverse address :) You could be running into inside/outside firewall behavior where your traffic is hitting the firewall which routes it back to the other box - making the inside interface of the firewall a possible bottleneck. You could also be running afoul of NIC capacity on the VPS - which shares it's overall capacity with N number of VPS on the same box. Of course if the 2 servers are in different locations you might be onto something with the hop count or total number of interfaces that examine the packets en route. And further up the stack (as Jared mentioned) are drivers, driver settings, connection pooling etc. That's all I can think of. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Chip Beck [mailto:[email protected]] Sent: Wednesday, October 07, 2009 4:22 PM To: cf-talk Subject: Re: CF load times on VPS Thanks to everyone for the responses. I wanted to respond in case any other novices to dedicated machines run into the same issue. After debugging, I realized the performance issue was in the database query time. As MySQL was being run on a separate box, for whatever reason the connection between my VPS and the database-hosting box was not as fast as the connection between my shared host and the MySQL database it was querying. Was this because of physical distance between boxes? Maybe they were housed in different locations? What are the major factors that contribute to the speed at which CF "talks" to MySQL or any database for that matter? On Wed, Sep 16, 2009 at 12:29 PM, Jordan Michaels <[email protected]>wrote: > > +1 > > The debugging information is what you need to get your hands on here. > I'm not familiar with how KA's setup is, but if you have access to the > CF Admin you can just turn it on from there, hit your page, and > debugging info will show up at the bottom. That should provide some > real insight as to what's causing the hang-up. > > Sending this question to KAVPS Support may also be a good idea. They > would be most familiar with their VPS's and maybe they've run into > this problem before. > > Warm regards, > Jordan Michaels > Vivio Technologies > http://www.viviotech.net/ > Open BlueDragon Steering Committee > Adobe Solution Provider > > > [email protected] wrote: > > Can you turn on debugging, or better yet, install SeeFusion on both > > servers? Then it's a simple matter of looking to see what is taking > > so long. Stack traces are your friend here. > > > > I *doubt* it is directly related to the fact that the file is big > > (unless you're talking megabytes-big) other than the fact that you > > have more room to cram poorly performing queries in a larger file. > > :) > > > > ~Brad > > > > -------- Original Message -------- > > Subject: CF load times on VPS > > From: Chip Beck <[email protected]> > > Date: Wed, September 16, 2009 9:41 am > > To: cf-talk <[email protected]> > > > > > > Forgive me in advance for this seemingly vague question, but I'm > > mostly just asking for suggestions on a general method of > > troubleshooting this... > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
