not if the bloody thing takes an hour or more to run, collate and present to the browser....
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Chad > Renando > Sent: Tuesday, 3 May 2005 9:03 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Long running query > > > 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/ > --- 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/
