Posted: Tue Jul 08, 2003 3:18 am Post subject: main display efficiency improvement
I've just finished up a modification to the main display routines to streamline the 8-part authorization scheme combined query approach (for the upcoming v3.0). There is an added query now that checks the Access table for user/user group/download/download group columns with a sum of zero (meaning nothing entered in that column, in turn meaning that authorization scheme is not in use). If any of those columns have a zero sum, the related authorization scheme loops are bypassed, i.e. if there are no user group entries, the following do not need to be looked up:
user group -> all files
user group -> file group
user group -> single file
user group -> subdirectory file group
The net effect is half as many authorization queries, each of which have quite a few table joins. My hope is this will lead me toward a more flexible way of organizing the main display output, although the primary objective was the efficiency improvements.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
