Posted by Jeff North on 10/31/57 11:46

On Sun, 30 Apr 2006 13:44:43 +1200, in comp.lang.php "windandwaves"
<winandwaves@coldmail.com>
<uEU4g.6659$0Y5.5349@news.xtra.co.nz> wrote:

>| Rik wrote:
>| > windandwaves wrote:
>| >> It is so hard for me to judge if the code is efficient. Really - who
>| >> knows. I know what efficient code is, but there are just so many
>| >> variables. Even making changes tot the php.ini could be huge.
>| >
>| > Yup, but previous suggestion with microtime() would give you an
>| > indication where the most time is taken.
>|
>| Yes, I may try that, but i found that pages load superfast one second and
>| almost not at all the next. I did some database work last night with a
>| script running through an entire table of 20,000 records one by one. I did
>| an echo for each line and it was really interesting to see that sometimes
>| the entire screen filled with echos within a split second, while the next
>| moment, each line would literally take one second.

When was the last time you 'defragged' your tables?
Optimize table <tablename>
Repair table <tablename> EXTENDED USE_FRM
---------------------------------------------------------------
I often wish that email had never been invented, but there’s
just no way I can get rid of it. So, day after day, several times
a day, I dutifully delete 99% of the emails I receive, and when
I’m not able to get at my email for a few days, I’ll leave the
machine at home running to pick it up every 10 minutes so I don’t
overflow some capacity somewhere, and just the other day I caught
myself wondering who will clean out my Inbox after I’m dead.

Charles Petzold. October 20, 2005
---------------------------------------------------------------

[Back to original message]