On Tue, 2002-10-08 at 23:15, Kees Jongenburger wrote:
> On Tuesday 08 October 2002 09:54 pm, Gerard van de Looi wrote:
> There are 3 more things that might be of interest to you
> 1- The security project that would very much like to enhance performance by
> delegating security rules to the database (select bigquery where
> bigcontratins and owner in "users")
1) Putting it all together, the retrieval should work in the following
way(?):
- After the 'list'-function has been called inside the bridge, a
query object is created.
- The query will be offert to the security layer, which returns an
new query object 'possible the same'
- The query has to be matched with the cache
- The query is offered to the database layer, that _should_ be able
to handle the query
- ?? The database layer will look in it's preparestatement-cache for
queries with the same structure ??
- Ask the query
- .....
2)
There is also the idea to reduce the amount of queries on the
database, by remembering with which query an node reference has been
retrieved.
Our query in the followin example is:
"get all news node's and return all the image's related to this
node."
In the normal situation(not multilevel, but let's say in taglibs):
- retrieve all the news nodes
- process every news-node
- look if there are related nodes of type image for this node
In the multilevel way:
- retrieve all the news nodes
- retrieve all the news nodes with an image related
- merge those 2 results.
In new -improved- situation-
- retrieve all the news nodes
- when the first news node is processed, we find out that we need
to get it's related images
- do the following query: getNewsNodes with all the Images
related(that it has to do a getNewsNode is in the news node)
- use the just fetched result also for the other news nodes..
This new way should offer an much easier to understand interface,
while still using the multilevel functionalitity (it can now even
split(follow images and urls) on a certain level)
But there are still some things that are not completely solved in
this story(should this be a project?)
(credits to mixhil and scb2 ;-) )
--
Eduard Witteveen Systeem Ontwikkelaar
Publieke Omroep, Gateway C Kamer 101
+31(0)356772910 http://www.omroep.nl/
Sed quis custodiet ipsos custodes? : The sixth Satire from Juvenal
