Script acceleration with ZEND/Truck MMCache

I have PHP script running complex query and then calculating data for
different conditions from received result set. Actually, it's doing the same
as if I would make several queries with different conditions on same data in
DB.

Calculating data in PHP instead of running several queries (each query has
joins on several tables with several hundreds of thousands of records)
shortened page generation time, but it's still not fast enough :-(

Now, I'm wondering if using some PHP accelerator/optimizer like Zend
Optimizer or Truck MM Cache would help me increase PHP script calculation
performance and shorten page generation time? As far as I could see, main
purpose of these accelerators is to decrease server load while high number
of users is requesting more or less simple content and in my case I have low
number of users requesting very demanding content.

Thx for any advice.

Munja

re: Script acceleration with ZEND/Truck MMCache

Actually, no. Those do opcode caching, which is basically the part where
the Zend Engine reads the php file and transform it into
machine-readable code. Those accelerators will not speed up your queries
at all. If you want to speed up queries, you might want to upgrade to
MySQL4 to benefit from the query caching.

Munja wrote:[color=blue]
> I have PHP script running complex query and then calculating data for
> different conditions from received result set. Actually, it's doing the same
> as if I would make several queries with different conditions on same data in
> DB.
>
> Calculating data in PHP instead of running several queries (each query has
> joins on several tables with several hundreds of thousands of records)
> shortened page generation time, but it's still not fast enough :-(
>
> Now, I'm wondering if using some PHP accelerator/optimizer like Zend
> Optimizer or Truck MM Cache would help me increase PHP script calculation
> performance and shorten page generation time? As far as I could see, main
> purpose of these accelerators is to decrease server load while high number
> of users is requesting more or less simple content and in my case I have low
> number of users requesting very demanding content.
>
> Thx for any advice.
>
> Munja
>
>
>
>[/color]

re: Script acceleration with ZEND/Truck MMCache

Munja:
[color=blue]
> I have PHP script running complex query and then calculating data for
> different conditions from received result set. Actually, it's doing the
> same as if I would make several queries with different conditions on same
> data in DB.
>
> Calculating data in PHP instead of running several queries (each query has
> joins on several tables with several hundreds of thousands of records)
> shortened page generation time, but it's still not fast enough :-(
>
> Now, I'm wondering if using some PHP accelerator/optimizer like Zend
> Optimizer or Truck MM Cache would help me increase PHP script calculation
> performance and shorten page generation time? As far as I could see, main
> purpose of these accelerators is to decrease server load while high number
> of users is requesting more or less simple content and in my case I have
> low number of users requesting very demanding content.[/color]

The first thing you should do is profile your code and find out where the
bottleneck is. Based on that you can try to optimize the script, or maybe
even rewrite critical parts of it in C.

re: Script acceleration with ZEND/Truck MMCache

"André Næss" <andrena.spamreallysucks@ifi.uio.no> wrote in message
news:bfds6q$v8$1@maud.ifi.uio.no...[color=blue]
> Munja:
>[color=green]
> > I have PHP script running complex query and then calculating data for
> > different conditions from received result set. Actually, it's doing the
> > same as if I would make several queries with different conditions on[/color][/color]
same[color=blue][color=green]
> > data in DB.
> >
> > Calculating data in PHP instead of running several queries (each query[/color][/color]
has[color=blue][color=green]
> > joins on several tables with several hundreds of thousands of records)
> > shortened page generation time, but it's still not fast enough :-(
> >
> > Now, I'm wondering if using some PHP accelerator/optimizer like Zend
> > Optimizer or Truck MM Cache would help me increase PHP script[/color][/color]
calculation[color=blue][color=green]
> > performance and shorten page generation time? As far as I could see,[/color][/color]
main[color=blue][color=green]
> > purpose of these accelerators is to decrease server load while high[/color][/color]
number[color=blue][color=green]
> > of users is requesting more or less simple content and in my case I have
> > low number of users requesting very demanding content.[/color]
>
> The first thing you should do is profile your code and find out where the
> bottleneck is. Based on that you can try to optimize the script, or maybe
> even rewrite critical parts of it in C.[/color]

I supose this is where I can maybe make some improvement. Do you know if
there is some PHP performance mesuring tool on the market (something
simillar to Borland Optimizeit for Java)?
Also, how complicated is to make parts of scripts in C? Does it requiere
dramatical Apache/PHP reconfiguration or it can be solved on more or less
simple INCLUDE and CALL from PHP ?

re: Script acceleration with ZEND/Truck MMCache

Munja:
[color=blue][color=green]
>> The first thing you should do is profile your code and find out where the
>> bottleneck is. Based on that you can try to optimize the script, or maybe
>> even rewrite critical parts of it in C.[/color]
>
> I supose this is where I can maybe make some improvement. Do you know if
> there is some PHP performance mesuring tool on the market (something
> simillar to Borland Optimizeit for Java)?[/color]

There was a thread here very recently about that, but I didn't read it...
Try searching google groups for "php profiler/profiling". It's really
unfortunate that PHP doesn't come with a profiler :/
[color=blue]
> Also, how complicated is to make parts of scripts in C? Does it requiere
> dramatical Apache/PHP reconfiguration or it can be solved on more or less
> simple INCLUDE and CALL from PHP ?[/color]

If you can isolate the bottleneck and turn it into a function written in C
it shouldn't be too hard. That way you could keep the rest of the script as
it is. I guess you should start here: http://www.php.net/manual/en/zend.php

A search also turned up this: http://www.devnewz.com/2002/0909.html

And I'm sure there are plenty more resources out there.

André Næss