DeleteProcess slow: Does "ON DELETE CASCASE" help?

Hi Shark developers,

we are using Shark with Oracle as DBMS and we have very complex
workflows with lot of activities. When a workflow is uninstalled it
takes a lot of time to delete all the workflow data from the database
(up to 15 minutes!). I found out that there is a <deleteCascade>
propertie in the conf/dods/OracleConf.xml file that is set to "false".
When I looked at the code I saw that this results in a lot of "lookups"
to resolve the database relations between activities, processes, ....
Now I have some questions:

1.) Is it true that when the <deleteCascade> propertie is set to "true"
the relations are resolved by the DBMS instead of resolving them in the
shark code (means: When I delete a process the DBMS finds all activitie
data that belong to that process and delete it also.)? Would this
property speed up the "delete process" procedure when set to "true"?

2.) How can I generate the Shark datamodel with the <deleteCascade>
propertie set to "true"? Is it neccessary to generate the DODS java
classes also? Or is it sufficient to only generate the database schema
(the *.sql files)?

@shark developers: The second point is no question for the DODS mailing
list: I have found "makesql" and "sqls" targets in your build.xml files.
Unfortunatly I'm not able to run them from the command line. How do you
call these targets to generate the *.sql-files for the datamodel?


Best Regards

Dipl. Ing. Oliver Wolters
(Systementwickler ENW)

--
ProCom Systemhaus und
Ingenieurunternehmen GmbH
Luisenstr. 41 - D-52070 Aachen

Tel. +49 241 51804-181
Fax +49 241 51804-30
http://www.procom.de
mailto:[email protected]

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