[Zope] MySQL Threading

[Jim Kutter]

I don't think threads are the answer here. I think what most people do
is load a page with an animated gif that animates a waiting icon or
something, and that page then calls (via JS or something I guess, I
don't know if a response.redirect call would work there) another page
which does the heavy lifting. Then the browser sits and waits for the
queries to finish, and when they do, it loads the new page.

No threads, no fuss :)

Please note though that I've been meaning to try this, so my suggestion
has yet to be tested... ;)

-jim

-----Original Message-----
From: Ralph vd Houdt [mailto:ralph at ezcompany.nl] 
Sent: Wednesday, December 17, 2003 9:36 AM
To: zope at zope.org
Subject: [Zope] MySQL Threading


Hi All,

I'm currently writing an application in which an report-page is based on
a
heavy SQL query. The query runs about 15 seconds (the result will be
stored
in a session). For this reason I want to create a waiting page which
checks
if the SQL query has finished running. Does anybody know if I can run
the
SQL query in a separate thread and redirect to the report-page when the
query has finished (by polling the thread). The results will be read
from
the session and used in the report-page.

Any clues?

Greetings Ralph


_______________________________________________
Zope maillist  -  Zope at zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )