Re: Using Oracle with Shark 1.1-2

Le Mardi 13 Septembre 2005 15:07, Dahl, Greg (BLM) - contr a écrit :
> Unfortunately, we shelved our workflow project in order to complete some higher priority projects before the end of the year.  

Poor shelves :) I bet i'll Investigate alone.

> 
> There is a mention about Oracle performance in setting one of the config files that talks about performance.  I believe it had something to do with caching.  However, I never did get time to try it out.

Am playing with it, but does not seems to have lots of influence :/

> 
> There are a few other things in Shark that may prevent us using it - mainly, the inability to dynamically assign groups of people to a work item.  It allows you to dynamically assign an individual user, but not a group.

For information, We nearly solved a problem i think similar here. We needed to assign to a group of user where the elligible users in the group where dependent on the workflow starter. (assign to 'boss of requester')
Thought there is no code here to do it yet, we checked and it seems inside the assignment manager we have all informations we need to do it.

Regards

> 
> Hopefully, when we pick this project back up, we'll be able to resolve these issues.
> 
> Greg
> 
> > -----Original Message-----
> > From: David Delbecq [mailto:[email protected]] 
> > Sent: Tuesday, September 13, 2005 7:58 AM
> > To: [email protected]
> > Subject: Re: [shark] Using Oracle with Shark 1.1-2
> > 
> > 
> > Le Mardi 30 Août 2005 15:37, Dahl, Greg (BLM) - contr a écrit :
> > > Has anyone else used any version of Oracle as the database 
> > for Shark?
> > > 
> > 
> > Hi, we have ran in the same problem here.
> > 
> > To integrate shark in our website, we created some taglib 
> > connecting to shark via CORBA. While performance were quite 
> > good using devel hsql database (about 80 
> > milliseconds/assignment) the oracle version is slow like hell 
> > (between 700 and 1400 milliseconds/assignment). I let you 
> > imagine my surprise when i loaded a webpage showing my 13 
> > assignments and it took about 15 seconds to load it :s
> > 
> > > When using a HSQL database for testing, we can create a new 
> > workflow 
> > > instance in less than a second.  When we use our same code but this 
> > > time point Shark to Oracle, it takes approximately 31 seconds.  For 
> > > instance, each process variable we add to our context map adds two 
> > > seconds to the set_process_context method.  The start method takes 
> > > approximately five seconds to run.
> > 
> > about 2 seconds to create a new process here using oracle. 
> > Simply by starting the test game in beanshell example XPDL
> > 
> > > 
> > > Normally, I would suspect a problem with our database server.  Yet, 
> > > this server has other tables in the same tablespace and our 
> > > application is using it which does multiple queries and table joins 
> > > with sub-second response time.
> > 
> > Same case here, server is highly used and has no know issue 
> > with load. 
> > We have a content managment stored on it, and it way faster 
> > to get metadatas of 100 documents in it then to get datas 
> > about 13 assignments in shark :(
> > 
> > > 
> > > Any suggestions where to start?  I'd hate to have to modify 
> > the Shark 
> > > source because we'd have to make the same modifications 
> > everytime we 
> > > wanted to upgrade. The inability to resolve these issues is 
> > going to 
> > > cause me to toss the last three months worth of work down the drain.
> > > 
> > 
> > I'd like to know if you located the probem already.
> > 
> > > Greg
> > > ******* Confidentiality Notice *******
> > > This email, its electronic document attachments, and the 
> > contents of 
> > > its website linkages may contain confidential health information.  
> > > This information is intended solely for use by the individual or 
> > > entity to whom it is addressed.  If you have received this 
> > information 
> > > in error, please notify the sender immediately and arrange for the 
> > > prompt destruction of the material and any accompanying attachments.
> > > 
> > > 
> > > 
> > > 
> > > 
> > 
> > -- 
> > David Delbecq
> > Royal Meteorological Institute of Belgium
> > 
> > -
> > Is there life after /sbin/halt -p?
> > 
> > 
> 
> 
> 

-- 
David Delbecq
Royal Meteorological Institute of Belgium

-
Is there life after /sbin/halt -p?

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws