[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zope
Subject:    [Zope] Zope returns a blank page
From:       Tim Edwards <Tim.Edwards () hwe ! com ! au>
Date:       2004-08-30 23:54:45
Message-ID: 32A6682AE1A4C0479E50D9F1BCFBC2810D56C9 () s-lyo-exc1
[Download RAW message or body]

Hi,

We are running an application on Zope that connects back to an MS SQL Server
2000 database (Using mxODBC). The app is written using ZPTs, Python scripts
and ZSQL methods. For performance reasons we have put all our queries in
stored procedures, often one stored procedure will be called (through a ZSQL
method) to retreive the data for a page and another to save data from that
page.

We have a problem where some of our users get a blank page while trying to
load up one of the screens in our app. This screen contains a list of
employees and their hours worked per day and in total for a week. The stored
procedure for this screen is a little slow (the sum calculations are done in
the SQL), it takes about 2 seconds to run through the Query Analyser. When
doing a 'View Source' we get just the basic HTML tags - DOCTYPE,HTML, HEAD,
BODY with nothing inside of them. So far this problem has only affected
users at remote (low bandwidth) sites.

Any ideas what could be causing Zope to return a blank page like this? Any
suggestions?

Thanks

Tim Edwards



_______________________________________________
Zope maillist  -  Zope@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 )
[prev in list] [next in list] [prev in thread] [next in thread]