[dev] Video and uploadprogress

[Michael Rubinsky]

Quoting Chuck Hagenbuch <chuck at horde.org>:

> Quoting Duck <duck at obala.net>:
>
>> 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.
>
> Lack of permission checking is the key there - yes we can do better in
> Horde, but of course you can make it faster without that. :)
>
>> Some ideas that comes in my mind
>> - move galleries out of DT (less sql work, no joins etc)
>
> Yup, that (for Ansel and also for folders in Trean) is the next step -
> need to separate the hierarchy stuff from permissions, though.
>
>> - cache shares (all application will benefit)
>
> If we do the above, there's not going to be that much of a share to
> cache, is there?
>
>> - cache galleries views (avoid all sql and php processing)
>
> As long as it can take into account permissions, that'd certainly be nice.


IIRC, we already do some type of perms caching in Ansel, no?


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/dev/attachments/20070906/34f9c423/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2013 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/dev/attachments/20070906/34f9c423/attachment-0001.bin