Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C8C633.3FC0BABE"
Subject: RE: sql transformer - display another site during transformer's work
Date: Wed, 4 Jun 2008 13:06:52 +0200
Message-ID: <F8E386B54CE3E6408F3A32ABB9A7908A282997@hai02.hippointern.lan>
Thread-Topic: sql transformer - display another site during transformer's work
Thread-Index: AcjGL9VcvalS9GBETceDc5mZn3+lPQAAbWxQAABjQvM=
References: <17643261.post@talk.nabble.com>
 <F8E386B54CE3E6408F3A32ABB9A7908A9C28A4@hai02.hippointern.lan>
 <17643824.post@talk.nabble.com>
 <F8E386B54CE3E6408F3A32ABB9A7908A9C28A6@hai02.hippointern.lan>
From: "Jeroen Reijn" <j.reijn@onehippo.com>
To: <users@cocoon.apache.org>,
	<users@cocoon.apache.org>

------_=_NextPart_001_01C8C633.3FC0BABE
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I agree with Jasha, that a background task would be the best solution.=20
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
=20
> -----Original Message-----
> From: navrc [mailto:navrkal.pavel@seznam.cz]=20
> Sent: woensdag 4 juni 2008 12:43
> To: users@cocoon.apache.org
> Subject: RE: sql transformer - display another site during=20
> transformer's work

> At the and of month we make some reports in pdf, there is=20
> 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:=20
> 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=20

www.onehippo.com
Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466=20
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


------_=_NextPart_001_01C8C633.3FC0BABE
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7652.24">
<TITLE>RE: sql transformer - display another site during transformer's =
work</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>I agree with Jasha, that a background task would be =
the best solution.<BR>
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.<BR>
<BR>
Jeroen<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: Jasha Joachimsthal [<A =
HREF=3D"mailto:j.joachimsthal@onehippo.com">mailto:j.joachimsthal@onehipp=
o.com</A>]<BR>
Sent: Wed 6/4/2008 12:59 PM<BR>
To: users@cocoon.apache.org<BR>
Subject: RE: sql transformer - display another site during transformer's =
work<BR>
<BR>
&gt; -----Original Message-----<BR>
&gt; From: navrc [<A =
HREF=3D"mailto:navrkal.pavel@seznam.cz">mailto:navrkal.pavel@seznam.cz</A=
>]<BR>
&gt; Sent: woensdag 4 juni 2008 12:43<BR>
&gt; To: users@cocoon.apache.org<BR>
&gt; Subject: RE: sql transformer - display another site during<BR>
&gt; transformer's work<BR>
<BR>
&gt; At the and of month we make some reports in pdf, there is<BR>
&gt; lots of big tables in the DB. So the selects take long time.<BR>
<BR>
Is the DB locked during the SELECT? Where do you store the reports or =
do<BR>
you display them directly from the pipeline? If so, you can better =
make<BR>
a background tak (cron job) generate the reports, write them to disk =
and<BR>
display the reports on the site from that location on the =
filesystem.<BR>
<BR>
&gt; View this message in context:<BR>
&gt; <A =
HREF=3D"http://www.nabble.com/sql-transformer---display-another-site-d">h=
ttp://www.nabble.com/sql-transformer---display-another-site-d</A><BR>
&gt; uring-transformer%27s-work-tp17643261p17643824.html<BR>
&gt; Sent from the Cocoon - Users mailing list archive at =
Nabble.com.<BR>
<BR>
Jasha Joachimsthal<BR>
<BR>
www.onehippo.com<BR>
Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam =
+31(0)20-5224466<BR>
San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA<BR>
94952-3329 +1 (707) 773-4646<BR>
<BR>
<BR>
---------------------------------------------------------------------<BR>=

To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org<BR>
For additional commands, e-mail: users-help@cocoon.apache.org<BR>
<BR>
<BR>
</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C8C633.3FC0BABE--