[dev] Video and uploadprogress

[Jan Schneider]

Zitat von Duck <duck at obala.net>:

> On Thursday 30 of August 2007 18:41:28 Chuck Hagenbuch wrote:
>> Even after datatree was mostly taken out of the picture? I'd love to
>> see it handle that sort of install, so any pointers on where the
>> bottlenecks are are welcome...
>
> oky. I loaded 10k galleries and 25k images on my laptop. I started to look at
> the sql code first since is often the most problematic part of the api. When
> I open the basic gallery list, I see 2 select queries are performed on DT. I
> extracted them en performed it in a benchmark script. The first takes 0.0025
> sec and the second takes 0.1975 sec. My dedicated app query takes only 0.0011
> on the full 75K galleries list. But of course has no joins or permission
> checking. Summarizing not taking in consideration Hrode speed compared to an
> dedicated application, only the sql queries needed are 180 times slower.
>
> Some ideas that comes in my mind
> - move galleries out of DT (less sql work, no joins etc)

This is definitely the mid-term goal. The earlier, the better.

> - cache shares (all application will benefit)

Share caching has already been implemented a while ago, even before  
the Share rewrite.

> - cache galleries views (avoid all sql and php processing)

This should only be a local short-term solution.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/