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
