The update I did also included adding a new table to the DB. Usually, I add
a "Site being updated" message and <cfabort> to the application.cfm file -
but I forgot this time, and when I was uploading the DB I think it probably
became corrupt as CF tried to write to it.
Initially it was working (including the new update) - so I'm going to try
the old DB file to see if that helps :(
Cheers
Will
> I've found (the hard way) that a "simple" query, such as one that grabs
only
> 1 record from only 6 tables of a poorly designed database, is enough to
> bring a server down .. even under no load otherwise ;). CF code /
database
> design can have a suprising affect on your server, so it's not impossible
> for you to experience problems, even with a simple query. Maybe if you
> posted the 'suspect' code, someone here might be able to help more?
>
> Todd Ashworth
> Web Application Developer
> Network Administrator
>
> Saber Corporation
> 314 Oakland Ave.
> Rock Hill, SC 29730
> (803) 327-0137 [111] (p)
> (803) 328-2868 (f)
> ----- Original Message -----
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 09, 2001 6:59 PM
> Subject: Re: Query crashes server?
>
>
> > Hehe, yup, all sorts of bad code can crash a server, including overly
> large
> > queries.
> >
> > I've done various bad things on production servers, until I made myself
do
> > all development on my personal system.
> > As a matter of fact my and the sysadmin at an isp got to know each other
> > very well when I was first learning CF. ;-)
> >
> > jon
> >
> > <cflocation url="#cgi.script_name#" addtoken="No">
> > ----- Original Message -----
> > From: "W Luke" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, March 09, 2001 6:43 PM
> > Subject: Query crashes server?
> >
> >
> > > Hi,
> > >
> > > Am pretty concerned as I think I've crashed my ISP's server. I wrote
a
> > > small app today for my site - an admin panel to add News items to the
> > site,
> > > and a page to pull the News items back. Both are using very basic
> > queries -
> > > no joins, or anything complicated. But the coincidence is a bit
> worrying.
> > > I used to work for the ISP, and know the servers makeup, but I'm just
> > asking
> > > whether a query (basic) can crash a server?
> > >
> > > Thanks
> > >
> > > Will
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
