[Zope-DB] Zope and MySQL Slowwwwwwwwwwwww on Windows
Deb B.
intranetdeb@yahoo.com
Tue, 24 Dec 2002 11:54:32 -0800 (PST)
--0-2018629970-1040759672=:50120
Content-Type: text/plain; charset=us-ascii
I came to this group today to see what I could find on a particular
ZOPE/MySQL issue I'm having. It relates to this thread, somewhat. I
hope someone can give me some insight.
I have ZOPE installed on a WIN98 machine that is acting as a
temporary server until we go through a complete network upgrade to
Windows 2000 Server, et. al. I have a development workstation that is
using Windows 2000 Professional. This machine is where I have
installed MySQL. So, I have ZOPE on one machine and MySQL on the
other.
I installed the myODBC from mysql.com because I couldn't get any of
the ZMySQLDA/MySQLdb products to work on any version of Windows
(obviously it favors the Unix/Linux environment). Well, Windows is
what I'm stuck with now.
I created databases, set up my ODBC connections, set up my Z SQL
Methods and SQL Forms (depending upon which databases I access) and
can access the databases with beautiful results on my ZOPE
pages......BUT.....the results are extremellllllllllllllllllllly slow
in coming. Even small databases with just a few records take forever
to come up even with the most basic of SQL statements using either
SQL Forms (for example, my Purchase Order database):
<dtml-var standard_html_header>
<dtml-if CheckPermissions>
<dtml-unless REFERER><dtml-call "REQUEST.set
('REFERER',HTTP_REFERER)"></dtml-unless>
<dtml-unless sqf_edit_method><dtml-call "REQUEST.set
('sqf_edit_method','edit')"></dtml-unless>
<h3>> <dtml-var title_or_id>: <dtml-var document_title> (List)</h3>
<P>
<a href="&dtml-URL2;/">Up</a> -
<a href="&dtml-REFERER;">Back</a> -
<a href="list?REFERER=&dtml-REFERER;">List</a> -
<a href="add?REFERER=&dtml-REFERER;">Add</a>
<br><br>
<table CELLSPACING='&dtml-table_cell_spacing;'>
<tr BGCOLOR='&dtml-internal_title_color;'>
<th>P.O.#</th>
<th>Order Date</th>
<th>P.O. Vendor</th>
<th>Items</th>
<th>Terms</th>
<th>Total</th>
</tr>
<dtml-call "REQUEST.set('bat_size',_.int(viewlistlen))">
<dtml-unless start_key><dtml-call "REQUEST.set('start_key',0)"></dtml-
unless>
<dtml-if "_.int(start_key)<0"><dtml-call "REQUEST.set
('start_key',0)"></dtml-if>
<dtml-call "REQUEST.set('next_key',_.int(start_key))">
<dtml-call "REQUEST.set('flag',0)">
<dtml-call "REQUEST.set('q','select * from po2002 where autoid
>= '+_.str(start_key)+' order by autoid asc')">
<dtml-try>
<dtml-in "SQL(q=q)" size=bat_size>
<dtml-if "_.int(next_key) < _.int(autoid)">
<dtml-call "REQUEST.set('next_key',autoid)">
</dtml-if>
<tr valign="top" align="left" BGCOLOR='<dtml-if "_.int(flag)
==1">&dtml-internal_c1_color;<dtml-else>&dtml-
internal_c2_color;</dtml-if>'>
<td><a href="&dtml-sqf_edit_method;?edit_key=<dtml-var
autoid>&REFERER=&dtml-REFERER;"><dtml-var autoid></a></td>
<td><dtml-var order_date></td>
<td><dtml-var vendor_name></td>
<td><dtml-var items></td>
<td><dtml-var terms></td>
<td><dtml-var total></td>
</tr>
<dtml-call "REQUEST.set('flag',1-_.int(flag))">
</dtml-in>
<dtml-except>
<h1>General error</h1>
<dtml-var errorinternalmethod>
</dtml-try>
</table>
<!-- navigation links -->
<br>
<a href="&dtml-URL0;?start_key=0&REFERER=&dtml-REFERER;">First</a> -
<a href="&dtml-URL0;?start_key=<dtml-var "_.int(start_key)-_.int
(bat_size)">&REFERER=&dtml-REFERER;">Prev</a> -
<a href="&dtml-URL0;?start_key=<dtml-var "_.int
(next_key)">&REFERER=&dtml-REFERER;">Next</a>
<dtml-else>
<dtml-var standard_html_header>
</dtml-if>
<dtml-var standard_html_footer>
and then Z SQL Methods (for example, a document log database):
Example 1:
select * from yr2000
Example 2:
SELECT * FROM yr2000 WHERE doc_author='JEF'
I also tried to set up a search form so users can perform searches
themselves instead of having to be limited to choosing from pre-
constructed reports I provide them. It's
daaaaaaaaaaaaaaawwwwwwwwwwwwwwwggggggggggggggg slowwwwwwwwwwwwwwwww
though. I even went so far as to perform table structure tests on my
MySQL databases to ensure I was optimizing them for the fastest
performance. Any searches done through a MySQL client returns quick
results but I want all of their access to these databases to be web-
based (i.e., through ZOPE site). Help!
Thanks.
Deb
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--0-2018629970-1040759672=:50120
Content-Type: text/html; charset=us-ascii
<P>I came to this group today to see what I could find on a particular <BR>ZOPE/MySQL issue I'm having. It relates to this thread, somewhat. I <BR>hope someone can give me some insight.<BR><BR>I have ZOPE installed on a WIN98 machine that is acting as a <BR>temporary server until we go through a complete network upgrade to <BR>Windows 2000 Server, et. al. I have a development workstation that is <BR>using Windows 2000 Professional. This machine is where I have <BR>installed MySQL. So, I have ZOPE on one machine and MySQL on the <BR>other. <BR><BR>I installed the myODBC from mysql.com because I couldn't get any of <BR>the ZMySQLDA/MySQLdb products to work on any version of Windows <BR>(obviously it favors the Unix/Linux environment). Well, Windows is <BR>what I'm stuck with now.<BR><BR>I created databases, set up my ODBC connections, set up my Z SQL <BR>Methods and SQL Forms (depending upon which databases I access) and <BR>can access the databases with beautiful results on my ZOPE <BR>pages......BUT.....the results are extremellllllllllllllllllllly slow <BR>in coming. Even small databases with just a few records take forever <BR>to come up even with the most basic of SQL statements using either <BR>SQL Forms (for example, my Purchase Order database):<BR></P>
<P><dtml-var standard_html_header><BR><dtml-if CheckPermissions><BR><BR><dtml-unless REFERER><dtml-call "REQUEST.set<BR>('REFERER',HTTP_REFERER)"></dtml-unless><BR><dtml-unless sqf_edit_method><dtml-call "REQUEST.set<BR>('sqf_edit_method','edit')"></dtml-unless><BR><BR><h3>> <dtml-var title_or_id>: <dtml-var document_title> (List)</h3><BR><P><BR><a href="&dtml-URL2;/">Up</a> -<BR><a href="&dtml-REFERER;">Back</a> -<BR><a href="list?REFERER=&dtml-REFERER;">List</a> -<BR><a href="add?REFERER=&dtml-REFERER;">Add</a><BR><BR><br><br><BR><BR> <BR><table CELLSPACING='&dtml-table_cell_spacing;'><BR><tr BGCOLOR='&dtml-internal_title_color;'><BR><th>P.O.#</th><BR><th>Order Date</th><BR><th>P.O. Vendor</th><BR><th>Items</th><BR><th>Terms</th><BR><th>Total</th><BR></tr><BR><BR><BR><dtml-call "REQUEST.set('bat_size',_.int(viewlistlen))"><BR><dtml-unless start_key><dtml-call "REQUEST.set('start_key',0)"></dtml-<BR>unless><BR><dtml-if "_.int(start_key)<0"><dtml-call "REQUEST.set<BR>('start_key',0)"></dtml-if><BR><dtml-call "REQUEST.set('next_key',_.int(start_key))"><BR><BR><dtml-call "REQUEST.set('flag',0)"><BR><BR><dtml-call "REQUEST.set('q','select * from po2002 where autoid <BR>>= '+_.str(start_key)+' order by autoid asc')"><BR><BR><BR><dtml-try><BR><dtml-in "SQL(q=q)" size=bat_size><BR><dtml-if "_.int(next_key) < _.int(autoid)"><BR> <dtml-call "REQUEST.set('next_key',autoid)"><BR></dtml-if><BR><BR><tr valign="top" align="left" BGCOLOR='<dtml-if "_.int(flag)<BR>==1">&dtml-internal_c1_color;<dtml-else>&dtml-<BR>internal_c2_color;</dtml-if>'><BR><BR><td><a href="&dtml-sqf_edit_method;?edit_key=<dtml-var <BR>autoid>&REFERER=&dtml-REFERER;"><dtml-var autoid></a></td><BR><td><dtml-var order_date></td><BR><td><dtml-var vendor_name></td><BR><td><dtml-var items></td><BR><td><dtml-var terms></td><BR><td><dtml-var total></td><BR></tr><BR><dtml-call "REQUEST.set('flag',1-_.int(flag))"><BR></dtml-in><BR><BR><dtml-except><BR> <h1>General error</h1><BR> <dtml-var errorinternalmethod><BR></dtml-try><BR><BR></table><BR><!-- navigation links --><BR><br><BR><a href="&dtml-URL0;?start_key=0&REFERER=&dtml-REFERER;">First</a> -<BR><a href="&dtml-URL0;?start_key=<dtml-var "_.int(start_key)-_.int<BR>(bat_size)">&REFERER=&dtml-REFERER;">Prev</a> -<BR><a href="&dtml-URL0;?start_key=<dtml-var "_.int<BR>(next_key)">&REFERER=&dtml-REFERER;">Next</a><BR><BR><dtml-else><BR> <dtml-var standard_html_header><BR></dtml-if><BR><dtml-var standard_html_footer><BR></P>
<P>and then Z SQL Methods (for example, a document log database):<BR><BR>Example 1:<BR><BR>select * from yr2000 <BR><BR>Example 2:<BR><BR>SELECT * FROM yr2000 WHERE doc_author='JEF'<BR><BR>I also tried to set up a search form so users can perform searches <BR>themselves instead of having to be limited to choosing from pre-<BR>constructed reports I provide them. It's <BR>daaaaaaaaaaaaaaawwwwwwwwwwwwwwwggggggggggggggg slowwwwwwwwwwwwwwwww <BR>though. I even went so far as to perform table structure tests on my <BR>MySQL databases to ensure I was optimizing them for the fastest <BR>performance. Any searches done through a MySQL client returns quick <BR>results but I want all of their access to these databases to be web-<BR>based (i.e., through ZOPE site). Help!<BR><BR>Thanks.<BR>Deb<BR><BR></P><p><br><hr size=1>Do you Yahoo!?<br>
<a href="http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com">Yahoo! Mail Plus</a> - Powerful. Affordable. <a href="http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com">Sign up now</a>
--0-2018629970-1040759672=:50120--