That's exactly it. Darryl
[EMAIL PROTECTED] wrote on 03/05/2005 11:07:07 AM: > Let me see if I understand this. Below is the process. > > 1. Write the SQL request to database. > 2. Create a CF page to execute the query, then create the file an email > it. > 3. Schedule the above page to run every couple of minutes to see if > there are any new queries. > 4. Make the query as complete or delete is when finished. > > > Sounds like a good plan. I'm going to try it. > > Thanks for all your help > > Brian > > > -----Original Message----- > From: Barry Beattie [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 3 May 2005 10:36 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Long running query > > > > thanx Darryl and Kym > > best ideas I've come across for this so far. > > Brian, are these any use for your situation? > > thanx again ppl > > cheers > barry.b > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of > > Kym Kovan > > Sent: Tuesday, 3 May 2005 10:30 AM > > To: CFAussie Mailing List > > Subject: [cfaussie] Re: Long running query > > > > > > Barry Beattie wrote: > > >> > Can you create a scheduled job on-the-fly to handle the request? > > > > > > yeah, Antony, > > > > > > on a non CF7Enterprise (with gateways) system this might be > > the only way > > > to keep it sane. > > > > > > have you (or anyone else out there in CFaussie land) done > > it this way? > > > > That rang a bell. We had a almost similar thing once in a > > Govt Intranet, > > the jobs ran for 30 mins or so, so we did just what was > > suggested, set > > up a once-only schedule. We had to allow for the fact that CF (v5 in > > that case) only checks the scheduler for its tasks/timing > > once every 15 > > mins so there is a possible 15 min delay before the newly > > scheduled item > > gets picked up so you have to set the "time to run" at least 15 mins > > into the future. > > > > We ended up using a different technique where we had a > > regularly running > > scheduled page that checked a database for tasks to do and > > ran them as > > required. Then the main site's code just wrote what was needed to be > > done into that database and it all happened automagically later on. > > > > Could be a way to go. > > > > > > Kym K > > > > > > > > > > thanx > > > barry.b > > > > > > > > > > > > -----Original Message----- > > > *From:* [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Behalf Of > > > *Antony Sideropoulos > > > *Sent:* Tuesday, 3 May 2005 9:26 AM > > > *To:* CFAussie Mailing List > > > *Subject:* [cfaussie] Re: Long running query > > > > > > Can you create a scheduled job on-the-fly to handle the request? > > > > > > Perhaps you could use CFFile to write a temporary CF > > page with the > > > query and all the user's params in it, and then create > > a once-off > > > scheduled job to run this temporary file, which would > > run the query, > > > save the file and email it? > > > > > > > > > On 5/3/05, *KNOTT, Brian* <[EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > > > Its an adhoc report that can be run at anytime with > > different > > > parameters. > > > > > > -----Original Message----- > > > From: Darryl Lyons [mailto:[EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>] > > > Sent: Tuesday, 3 May 2005 9:04 AM > > > To: CFAussie Mailing List > > > Subject: [cfaussie] Re: Long running query > > > > > > Is it once-off report, or does it rely on specific > > user details > > > at the > > > time (e.g. personalised)? > > > > > > Darryl > > > > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>wrote on > > > 03/05/2005 08:44:19 AM: > > > > > > > Not an option. > > > > > > > > -----Original Message----- > > > > From: Darryl Lyons [mailto:[EMAIL PROTECTED] > > > <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 > > <http://dangermoose.blogspot.com> > > > > > > > > [EMAIL PROTECTED] > > > <mailto:[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 > > <http://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] > > > <mailto:[EMAIL PROTECTED]> > > > > > To unsubscribe send a blank email to > > > [EMAIL PROTECTED] . > > > > > daemon.com.au <http://daemon.com.au> Aussie Macromedia > > > Developers: > > > http://lists.daemon.com.au/ > > > > > > > > > > > > To unsubscribe from this email please forward > > this email to > > > > [EMAIL PROTECTED] > > > <mailto:[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] > > > <mailto:[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] > > <mailto:[EMAIL PROTECTED]> > > > > To unsubscribe send a blank email to > > > [EMAIL PROTECTED] > > > <mailto:[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 > > <http://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] > > <mailto:[EMAIL PROTECTED]> > > > > To unsubscribe send a blank email to > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]> > > > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > > To unsubscribe from this email please forward this email to > > > [EMAIL PROTECTED] > > > <mailto:[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] > > > <mailto:[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] > <mailto:[EMAIL PROTECTED]> > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > <mailto:[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 > > <http://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] <mailto:[EMAIL PROTECTED]> > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > <mailto:[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/ > > --- > 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/ 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/
