RE: Using Oracle with Shark 1.1-2

Unfortunately, we shelved our workflow project in order to complete some higher priority projects before the end of the year.  

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.

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.

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?
> 
>

--
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