You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by navrc <na...@seznam.cz> on 2008/06/04 12:03:15 UTC
sql transformer - display another site during transformer's work
Hallo,
I use sql transformer. Some heavy SELECTs takes a long time (hours). Is some
possibility to display another site during transformer's work and when work
is finished show the result.
Thanks.
Pavel Navrkal
--
View this message in context: http://www.nabble.com/sql-transformer---display-another-site-during-transformer%27s-work-tp17643261p17643261.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: sql transformer - display another site during transformer's work
Posted by Jeroen Reijn <j....@onehippo.com>.
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:j.joachimsthal@onehippo.com]
Sent: Wed 6/4/2008 12:59 PM
To: users@cocoon.apache.org
Subject: RE: sql transformer - display another site during transformer's work
> -----Original Message-----
> From: navrc [mailto:navrkal.pavel@seznam.cz]
> Sent: woensdag 4 juni 2008 12:43
> To: users@cocoon.apache.org
> 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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: sql transformer - display another site during transformer's work
Posted by Jasha Joachimsthal <j....@onehippo.com>.
> -----Original Message-----
> From: navrc [mailto:navrkal.pavel@seznam.cz]
> Sent: woensdag 4 juni 2008 12:43
> To: users@cocoon.apache.org
> 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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: sql transformer - display another site during transformer's
work
Posted by navrc <na...@seznam.cz>.
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.
Pavel
--
View this message in context: http://www.nabble.com/sql-transformer---display-another-site-during-transformer%27s-work-tp17643261p17643824.html
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
RE: sql transformer - display another site during transformer's work
Posted by Jasha Joachimsthal <j....@onehippo.com>.
Hello Pavel,
> -----Original Message-----
> From: navrc [mailto:navrkal.pavel@seznam.cz]
> Sent: woensdag 4 juni 2008 12:03
> To: users@cocoon.apache.org
> Subject: sql transformer - display another site during
> transformer's work
>
>
> Hallo,
> I use sql transformer. Some heavy SELECTs takes a long time
> (hours). Is some possibility to display another site during
> transformer's work and when work is finished show the result.
What is the purpose of those heavy SELECTs? If it's for data
replication, I wouldn't use Cocoon for that. If it's for live data
retreival, nobody wants to wait hours for a response.
> View this message in context:
> http://www.nabble.com/sql-transformer---display-another-site-d
> uring-transformer%27s-work-tp17643261p17643261.html
> Sent from the Cocoon - Users mailing list archive at Nabble.com.
Regards,
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org