Oh, I know all about how bad Access is. The fact remains that this is an old, semi-poorly written application (from a maintenance standpoint, not a functional one), which would require LOTS of attention to upgrade to mySQL or SQL Server. With all the billable work piling up around here, I'd like to just leave this app until I can give it the proper time for the upgrade.
All of my apps these days are using a "real" DB. I really am impressed with mySQL lately, though. As Ray Camden wrote in his blog a few days ago, there is a whole world of features that I didn't ever know about. Anyways, thanks for the help guys, it was appreciated. Ray Burns, John D wrote: > Even mySQL would be an upgrade if you can't afford the SQL upgrade. At > least it's reliable. > > > 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 5:17 PM > To: CF-Talk > Subject: Re: from 6 to 7 > > Aha! > > After they finally escalated the issue to the higher-ups, I found the > issue. > > There are two DB apps running in background. They have the server set > up so that only one connection can be open at a time when connecting to > Access DB's. So, the scripts are timing out when concurrent requests > are being made to two different Access DB's. They claim that they > worked with Macromedia and this was the solution to a "stability issue > with Win2003". > > Whatever - I guess it's time to upgrade to a SQL Server DB. > > Thanks for the help and suggestions, guys. > > Russ wrote: > >>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:230315 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