Yeah, I had patient users when I did it on mine. ;) Chad
On 5/3/05, Barry Beattie <[EMAIL PROTECTED]> wrote: > > 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/ > --- 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/
