depends - if you have the "restart after n unresponsive threads this might do it... your scripts might be running for too long according to timeout settings then the server restarts itself.
Friday, March 7, 2003, 4:28:42 PM, you wrote: RM> Problem that is being overlook is why would it cause the CF server to restart? if is the query took to long then wouldn't it time out or generate some other error instead? RM> rob RM> -----Original Message----- RM> From: gary menzel <[EMAIL PROTECTED]> RM> To: CFAussie Mailing List <[EMAIL PROTECTED]> RM> Date: Friday, March 07, 2003 4:23 PM RM> Subject: [cfaussie] RE: Error Occurred While Processing Request RM> I had another thought on this as well..... RM> If you are using SQL*Server you may consider having a Full Text index created. RM> Then you would use functions like CONTAINS(columnname,conditions) or CONTAINSTABLE, etc. inside your query instead of using LIKE. RM> Gary Menzel RM> IT Operations Brisbane -+- ABN AMRO Morgans Limited RM> Level 29, 123 Eagle Street BRISBANE QLD 4000 RM> PH: 07 333 44 828 FX: 07 3834 0828 RM> [EMAIL PROTECTED] wrote on 03/07/2003 01:58:48 PM: RM> > Greg RM> > RM> > The query looks custom built to take the longest possible time to execute RM> > RM> > like steve said, use of the word "OR" is best kept to a minimum. If RM> > you think about it, it makes the questions rather non-specific, and RM> > increases the amount of searching (work) the db has to do. "LIKE" is RM> > the same. Indexes can't be used if you specify "like". RM> > RM> > The select statement is also non-specific (select *). RM> > RM> > If you want it to run well, change the question to something like 'select RM> > BILL_LNAME, BILL_FNAME from members where userid = 5' RM> > That should run as quick as a flash if you've got an index on the RM> > userid column. RM> > RM> > The querry on the page looks like this > RM> > RM> > <cfparam name="LOOKUP" default="Y"> RM> > <cfparam name="SearchTerms" default=""> RM> > <cfparam name="TYPE" default=""> RM> > RM> > <cfquery name="Search" datasource="toolshed" username="" password=""> RM> > SELECT * FROM MEMBERS RM> > <cfif Lookup is "Y"> RM> > WHERE USERID LIKE '%#searchterms#%' or RM> > BILL_FNAME LIKE '%#searchterms#%' or RM> > BILL_LNAME LIKE '%#searchterms#%' or RM> > BILL_COMPANY LIKE '%#searchterms#%' or RM> > BILL_ADDRESS LIKE '%#searchterms#%' or RM> > BILL_CITY LIKE '%#searchterms#%' or RM> > BILL_STATE LIKE '%#searchterms#%' or RM> > BILL_ZIP LIKE '%#searchterms#%' or RM> > BILL_PHONE LIKE '%#searchterms#%' or RM> > BILL_FAX LIKE '%#searchterms#%' or RM> > BILL_COUNTRY LIKE '%#searchterms#%' or RM> > BILL_EMAIL LIKE '%#searchterms#%' RM> > </cfif> RM> > ORDER BY BILL_LNAME, BILL_FNAME RM> > </cfquery> RM> > RM> > any pointers RM> > Thanks in advance RM> > regards greg stone RM> > --- RM> > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] RM> > To unsubscribe send a blank email to [EMAIL PROTECTED] RM> > MX Downunder AsiaPac DevCon - http://mxdu.com/ RM> > --- RM> > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] RM> > To unsubscribe send a blank email to [EMAIL PROTECTED] RM> > RM> > MX Downunder AsiaPac DevCon - http://mxdu.com/ RM> > Daniel Morphett RM> > Web Developer, DBA RM> > www.daemon.com.au --- RM> > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] RM> > To unsubscribe send a blank email to [EMAIL PROTECTED] RM> > RM> > MX Downunder AsiaPac DevCon - http://mxdu.com/ **************************************************************************** RM> If this communication is not intended for you and you are not an authorised RM> recipient of this email you are prohibited by law from dealing with or RM> relying on the email or any file attachments. This prohibition includes RM> reading, printing, copying, re-transmitting, disseminating, storing or in RM> any other way dealing or acting in reliance on the information. If you RM> have received this email in error, we request you contact ABN AMRO Morgans RM> Limited immediately by returning the email to [EMAIL PROTECTED] RM> and destroy the original. We will refund any reasonable costs associated RM> with notifying ABN AMRO Morgans. This email is confidential and may contain RM> privileged client information. ABN AMRO Morgans has taken reasonable steps RM> to ensure the accuracy and integrity of all its communications, including RM> electronic communications, but accepts no liability for materials RM> transmitted. Materials may also be transmitted without the knowledge of ABN RM> AMRO Morgans. ABN AMRO Morgans Limited its directors and employees do not RM> accept liability for the results of any actions taken or not on the basis RM> of the information in this report. ABN AMRO Morgans Limited and its RM> associates hold or may hold securities in the companies/trusts mentioned RM> herein. Any recommendation is made on the basis of our research of the RM> investment and may not suit the specific requirements of clients. RM> Assessments of suitability to an individual's portfolio can only be made RM> after an examination of the particular client's investments, financial RM> circumstances and requirements. RM> **************************************************************************** RM> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ RM> --- RM> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] RM> To unsubscribe send a blank email to [EMAIL PROTECTED] RM> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
