I agree with Jasha, that a background task would be the best solution. Another solution would be that if it takes minutes, you could try to use Ajax for generating the files in the background and displaying a processing task to the user.
Jeroen -----Original Message----- From: Jasha Joachimsthal [mailto:[EMAIL PROTECTED] Sent: Wed 6/4/2008 12:59 PM To: [email protected] Subject: RE: sql transformer - display another site during transformer's work > -----Original Message----- > From: navrc [mailto:[EMAIL PROTECTED] > Sent: woensdag 4 juni 2008 12:43 > To: [email protected] > Subject: RE: sql transformer - display another site during > transformer's work > At the and of month we make some reports in pdf, there is > lots of big tables in the DB. So the selects take long time. Is the DB locked during the SELECT? Where do you store the reports or do you display them directly from the pipeline? If so, you can better make a background tak (cron job) generate the reports, write them to disk and display the reports on the site from that location on the filesystem. > View this message in context: > http://www.nabble.com/sql-transformer---display-another-site-d > uring-transformer%27s-work-tp17643261p17643824.html > Sent from the Cocoon - Users mailing list archive at Nabble.com. Jasha Joachimsthal www.onehippo.com Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466 San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA 94952-3329 +1 (707) 773-4646 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
