> -----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]
