I suppose setting a mega-sized requestedtimeout value and letting it do its thing is not an option?
Chad who's old-school is more like grade-school On 5/3/05, KNOTT, Brian <[EMAIL PROTECTED]> wrote: > Not an option. > > -----Original Message----- > From: Darryl Lyons [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 3 May 2005 8:40 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Long running query > > Brian, > > Can you export the data into a "warehouse" table in another database? You > might be able to use this speed up the query, even for use asynchronously > (or not). > > Darryl Lyons > http://dangermoose.blogspot.com > > [EMAIL PROTECTED] wrote on 03/05/2005 08: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] > > daemon.com.au Aussie Macromedia Developers: http://lists.daemon.com.au/ > > To unsubscribe from this email please forward this email to > [EMAIL PROTECTED] > > This email message is confidential and may be privileged. Unauthorised use, > copying or distribution of any part of this email > including attachments is prohibited. If you are not the intended recipient > please forward the email to [EMAIL PROTECTED] > and delete the original. > > ABN AMRO Morgans Limited and its associates hold or may hold securities in > the companies/trusts mentioned herein. Any general > advice included in this email has been prepared without taking into account > your objectives, financial situation or needs. Before > acting on the advice, you should consider its appropriateness or discuss > with one of our investment advisors. > > To the extent permitted by law we exclude (and where the law does not permit > an exclusion, limit to the extent permitted by law) all > liability for any direct, indirect and consequential costs, losses, damages > and expenses incurred in any way (including but not limited > to that arising from negligence), connected with any use or access to this > email or any reliance on information contained in this email > or any attachments. > > ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of > ASX Group A Principal Member of the > Financial Planning Association > > --- > 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/ > --- 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/
