As a side question, does the site appear to perform slower on the new server? If not, it seems rather odd that the server times out periodically trying to connect to the database but that it doesn't act slower on regular page calls. As a quick fix, you could possibly increase the timeout time for the connection to the database. That doesn't solve the root problem, but may get it to at least stop timing out.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:05 PM To: CF-Talk Subject: Re: from 6 to 7 That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to another....not just different segments of "their" network. On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > As well as the question other have asked about "which database" are > you using, I also wonder if this server sits in a different segment of > the network than the previous one. If the server and the database are > further removed, they could have network issues that are causing > longer delays in the calls to the database. You may want to ask if > there is a database server in the same segment as your server that you > could use instead of your old one. That's a shot in the dark, but you > may want to research it. > > > John Burns > Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | > Web Developer > > > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 3:26 PM > To: CF-Talk > Subject: from 6 to 7 > > Hey all: > > I'm having an issue with my hosting company that I wanted to run by > everyone. > > I've had a site up and running fine at this particular host for quite > a while now. While it is not the most elegantly coded site (one of my > first large projects), it works fine. To take advantage of newer > hosting options (more disk space), we migrated this site from a > CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > most menial database queries are sometimes timing out. Mind you, this > is not occurring all the time with the same query, it seems to be > happening with different queries at different times. > > I'm now in a debate with said host - they are telling me that it's > because of my coding in general, they say I need to "upgrade" my > coding to adapt to CF7. I say this is pure BS, a copout answer. From > what I know, the release of CF7 was more a "features" release, so this > shouldn't matter, right? > > Ray > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
