Your correct Barry. There must be a system where a web page can start a process going. The browser does not need to wait for a response as the results are emailed.
Brian -----Original Message----- From: Barry Beattie [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 May 2005 8:36 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Long running query Scott, these suggestions may help, but we're got reports that can take an hour or so to run. One of the existing windows reports (that we have to rewrite in CF) takes the best part of a weekend to run (believe it or not) - Brian may have a similar situation. You'd like to think you could get the most performant queries so this would never happen, but... barry.b > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott > Thornton > Sent: Tuesday, 3 May 2005 8:27 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Long running query > > > > 1. Can you make the query into a stored procedure? > > 2. Add more parameters to return less data? > > 3. Modify the query to make it work faster? > > 4. Schedule the page (to remove browser time out problems)? Create the > file daily (at midnight say), and have the user pick it up if > they want > it? > > > > >>> [EMAIL PROTECTED] 3/05/2005 8:05:59 am >>> > I have a query that accesses a very slow database. Most of the time > it > times out. One way I was thinking of getting around this way > to create > a CF > page that would run the query, export it to a file and them email the > file > to the user. This works some of the time. > > > > Is this the best method of doing it. Optimising the database or > speeding it > up are not an option. > > > > Brian Knott > > > > > -------------------------------------------------------------- > --------------------- > This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 > 722 or one > of its related entities "Suncorp". > > Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or > on 13 11 55 or at suncorp.com.au. > > The content of this e-mail is the view of the sender or stated author > and does not necessarily reflect the view of Suncorp. The content, > including attachments, is a confidential communication between Suncorp > and the intended recipient. If you are not the intended recipient, any > use, interference with, disclosure or copying of this e-mail, > including > attachments, is unauthorised and expressly prohibited. If you have > received this e-mail in error please contact the sender > immediately and > delete the e-mail and any attachments from your system. > > If this e-mail constitutes a commercial message of a type that you no > longer wish to receive please reply to this e-mail by typing > Unsubscribe > in the subject line. > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities "Suncorp". Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
