Re: [Phpgroupware-users] phpWebHosting scaleability

[Chris Weiss]

holy excessive queries!  12 selects for each file in the dir!  it's not doing 
every file in the
tree, but it is doing every dir in the tree and is doing selects 2 times for 
every file, and is
checking permissions for every file, which is odd, i thought perms were simply 
group base,
on the root of the dir.

i'm told this is being worked on though....


Steven Wright (address@hidden) wrote:
>
>
>I just tried to use phpWebHosting as a filemanager tool for an extremely
>large file tree (on the order of 50k files) and brought the machine to its
>knees.  (Obviously, I didn't add each of those files through phpGW, but
>used a perl script to populate the database, then I went in to look at the
>results.)  Looking at the mysql logs, phpGW seems to be doing a query on
>every file in the tree, regardless of whether it is in the current
>directory or not.
>
>Has anyone dealt with this before?  Are all of those queries needed for
>each page?  If it was just working on the files in the current directory,
>I think it would be okay.
>
>Thanks,
>Steve Wright
>
>-----                        address@hidden                        -----
>When I could find voice,  I shrieked aloud in agony,  "Either this is madness
>or it is Hell."  "It is neither," calmly replied the voice of the Sphere, "it
>is Knowledge."                                 _Flatland_, by Edwin A. Abbott
>-----                                                                   -----
>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>