<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>If there is a big discrepancy between query time and page execution time, as you indicate here, then it would indicate code is slowing it down. I usually find the culprit to be one or more poorly coded hooks or some modules that should be caching data and aren't. with some careful review of the Devel log, you may get some indication of who that is. If you use accesslog and/or statistics, try turning them off briefly and see if that is a problem. It might be helpful to insert some timer_xxx functions (see the API) to narrow it down.</DIV>
<DIV> </DIV>
<DIV>On a poitive note, 540 queries in 69 milliseconds is pretty darned good. If I were you, I would postpone the VPS and do some sleuthing.<BR> </DIV>
<P><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR><FONT size=2 face=Tahoma>
<DIV style="FONT-FAMILY: Courier New, monaco, monospace, sans-serif; FONT-SIZE: 10pt">
<HR SIZE=1>
</DIV>
<DIV style="FONT-FAMILY: Courier New, monaco, monospace, sans-serif; FONT-SIZE: 10pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Fred Jones</DIV>
<DIV style="FONT-FAMILY: Courier New, monaco, monospace, sans-serif; FONT-SIZE: 10pt"></FONT><BR>>>> I turned on devel and I see page execution times of 3 seconds on<BR>>>> average, however. I think that's very high. I will try to analyze if I<BR>>>> can and see what's slowing down this site, but in the meantime here<BR>>>> are my questions:<BR><BR>Thanks for the responses. Seems MySQL is not the culprit because this<BR>is typical for an authenticated user:<BR><BR>Page execution time was 3455.42 ms. Executed 540 queries in 69.4 milliseconds.</DIV></DIV></div></body></html>