Most ISP's should offer at least SQL EXPRESS 2005 for free... > -----Original Message----- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 24, 2006 9:49 AM > To: CF-Talk > Subject: RE: from 6 to 7 > > 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:230317 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
