On Wed, 2002-07-03 at 22:23, Gerard van Enk wrote:
> Do you have some numbers, what this drastic performance drawback will be?
Current situation(simplified):
News.getNodes() --> SELECT * FROM NEWS;
(all nodes will be news nodes)
Object.getNodes() --> SELECT * FROM OBJECT;
(all nodes will be object nodes)
When changed-situation(simplified):
News.getNodes() --> SELECT * FROM NEWS;
(all nodes will be news nodes(and news is not extended))
Object.getNodes() --> SELECT * FROM OBJECT;
SELECT * FROM NEWS WHERE NUMBER=1;
SELECT * FROM NEWS WHERE NUMBER=2;
....
....
....
.... SELECT * FROM IMAGES WHERE NUMBER=99;
SELECT * FROM URLS WHERE NUMBER=100;
SELECT * FROM POOLS WHERE NUMBER=101;
(all nodes will be the nodes they actually are)
As you can see, it can drop the performance drasticly at the first
query. It is true, that when the node-cache is filled, this aint a
problem, but since it could have a negative impact, i didnt dare to turn
it to 'true'
I dont have any numbers, since they are depended on the builder
configuration / queries / nodecache.
--
Eduard Witteveen Systeem Ontwikkelaar
NOS Internet, Gateway C Kamer 107
+31(0)356772910 http://www.omroep.nl/
Sed quis custodiet ipsos custodes? : The sixth Satire from Juvenal
