Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file?
If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 4:55 PM > To: CF-Talk > Subject: Re: from 6 to 7 > > Sorry, was out shoveling snow. :( > > Nope, this is an Access DB. I know that's not the best situation, but > like I said, it was my first project, and it worked fine on the other > server. > > And, just so it's known, I'm on a shared host, so there is no access to > anything outside my web root, including the administrator. > > Ray > > Jim Wright wrote: > > 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:230276 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
