hmmm...got me thinking...what is the actual licensing for sql express? so far my googling has failed...previous versions of MSDE weren't good for anything more than a small app due to the throttling, but this version doesn't have that anymore...the limits of 1GB of RAM, 1 processor and 4GB database size put a lot off web apps within reach on that platform. Does anyone know of a link to the actual license agreement for SQL Express? I'd like to see what the fine print says.
On 1/24/06, Russ <[EMAIL PROTECTED]> wrote: > 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:230368 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
