[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference utrop1::linkworks_v3

Title:	LinkWorks V3.0 Notes Conference
Notice:	LNX_APO = APO issues, LINKWORKS_V3 = V3.0 issues
Moderator:	tacklr.apd.dec.com::TACK_Lm::TACK_L

Created:	Tue Jun 28 1994
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	2269
Total number of notes:	8338

2121.0. "performance with user attribute" by ATYISA::61569::coutant () Wed Feb 12 1997 14:25

Hi,

A customer wants to use the WEB Worker. The WEB Worker can search object 
with a User attribute instead of the objectID (URL attribute). So, the 
customer associated a URL attribute (String 132 caracters) to the 
UserObject class. Then all classes inherit the URL attribute. Of course 
this attribute is indexed and must be unique.

In order, to manage unique attribute, we created a list of URL attributes 
already created which is a compound object containing ObjectWithAttribute. 
Before creating an object, we check if the URL is unique (not in the List). 
But, we are afraid of performance. We have few object created and we need 
10 seconds to create new objects. What will be the performances when 500000 
URL attributes will be in the list?

What is your opinion on this?


Patrice

T.R	Title	User	Date	Lines
2121.1		elec1.uto.dec.com::wijermars_v	`Wed Feb 12 1997 16:37`	9
	Hi, I wonder how you get the attributes of the URL objects. The performance depends very much on this. I would implement the unique URL in a different way by making (a part of) the object reference in the URL. Vincent.
2121.2	Object ID is not possible	ATYISA::61569::coutant	`Thu Feb 13 1997 11:58`	34
	Vincent, >>I wonder how you get the attributes of the URL objects. >>The performance depends very much on this. To search if the URL exists already, we do an APOQuery from CPL with apodll32.dll. Do you have a better idea? >>I would implement the unique URL in a different way by making (a part of) the >>object reference in the URL. Let me try to explain the customer context. He wants to use LNX to get Object framework functionalities: Workflow, access right control, storage, programming, and so on. He doesn't want to be linked to Digital, Microsoft and so on. So, he wants to use the internet technology. Most of documents will be HTML documents. Using HTML, to link a document to another, the URL is used. So, it is not possible to put something like <ahref="http://www.digital.com/www2lnx?FF0100000000000000000000000010BD00C3></a> in the documents. If you stop to use LNX, what could you do with your document and what users can understand? So, we will use readable URL. Something like: <ahref="/DECCabinet/Software/LinkWorks"></a> That's better, isn't it. Thanks for help Patrice
2121.3		elec1.uto.dec.com::wijermars_v	`Wed Feb 19 1997 12:55`	8
	In this case the query would look like select x where x.urlattribute='yyyy' Right ? To make this perform you have to set an index on urlattribute for all classes that have this attribute. You can specify this during attribute assignment. Vincent
2121.4	and performances ?	ATYISA::61569::coutant	`Mon Mar 03 1997 16:08`	18
	Vincent, >>In this case the query would look like >>select x where x.urlattribute='yyyy' >>Right ? Yes, that's the query, but my question was: performances expected when more than 500 000 objects will be created? >>To make this perform you have to set an index on urlattribute for all >>classes attribute. You can specify this during attribute assignment. The URL attribute (String 132 caracters) is assigned to the UserObject class. Then all classes inherit this attribute. Of course this attribute is indexed. So, I don't think I should specify it for each class, isn't it? Thanks for help Patrice
2121.5		maandaj.uto.dec.com::~::ANONYMOUS%	`Tue Mar 04 1997 12:52`	8
	If this attribute is indexed, you don't have to worry. It will give a good performance even if you grow well behind the 500.000 objects. Attribute assignments are derived. So if you assign an attribute to UserObject, all classes from that point on will have the attribute assigned automatically. Regards, Jos