Tapestry 4.1 long sql execution causes tapestry engine ints

[Bogdan Stojkovic <bo...@bitsyu.net>]

Hi all,

I have small problem, if anyone can help....
I'm using tapestry 4.1, in one page I have link in witch I go to DB, execute sql and this result set is displayed in table. This sql execution takes >10sec. If in that time I click on link again -> tapestry engine init is happend, but old sql is still executing in background as zombi proces, as I think. With many users maniacly clicking on same button several times (with no reason to do that :-) ) or other links on page, I face resource problem, it takes more memory and in my log I see a lots of engine inits, application is starting to work mutch slower.

Anyone have idea how to solve problem with clicking on other links on page while long sql execution is in progress? (maybe to intercept this engine inits and check for current page status - but i do not know how?)

Thanks,
Bogdan

Re: Tapestry 4.1 long sql execution causes tapestry engine ints

[Howard Lewis Ship <hl...@gmail.com>]

That's going to be a challenge; have you thought about addressing this
either at the database end (optimize your database, indexes, etc.) or
at the client end (javascript to prevent re-submits)?

On Thu, Apr 16, 2009 at 2:35 PM, Bogdan Stojkovic <bo...@bitsyu.net> wrote:
> Hi all,
>
> I have small problem, if anyone can help....
> I'm using tapestry 4.1, in one page I have link in witch I go to DB, execute sql and this result set is displayed in table. This sql execution takes >10sec. If in that time I click on link again -> tapestry engine init is happend, but old sql is still executing in background as zombi proces, as I think. With many users maniacly clicking on same button several times (with no reason to do that :-) ) or other links on page, I face resource problem, it takes more memory and in my log I see a lots of engine inits, application is starting to work mutch slower.
>
> Anyone have idea how to solve problem with clicking on other links on page while long sql execution is in progress? (maybe to intercept this engine inits and check for current page status - but i do not know how?)
>
> Thanks,
> Bogdan



-- 
Howard M. Lewis Ship

Creator of Apache Tapestry
Director of Open Source Technology at Formos

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org