[enhydra] DeleteCascade on PostgreSQL

Hi,

I'm doing some perfomance tests in a project running on top of the new 
Enhydra 6.4.1 (Tomcat version) and a PostgreSQL DB engine (7.3.9). I've 
noticed that on the DODS configuration that was installed with this 
Enhydra, the DeleteCascade parameter for PostgreSQL is set to false. 
This means that the DB reference integrity will be guaranteed by the 
data layer generated by DODS, and for what I understood this is done by 
fetching (on DB) the objects that have references to the object being 
changed, and performing on them the required changes (if needed). So for 
instance if I have a DO named A that references B and I try to delete B 
using the DODS layer, this will result in following SQL operations:

1. Select B from DB and then delete it by invoking the delete method on 
its DO.
2. Select A from DB (triggered by DODS)
3. Delete A and B from DB.

If this integrity is guaranteed by the DB engine, the 2nd operation and 
part of the 3rd will be automatically  performed by the DB engine 
resulting in a performance improvement. This is what I wanted to explore 
in the project I'm in, but first I would like to know from you if 
there's any known issue related to the setting of this parameter to true 
(since by default it is setted to false).

Thanks in advance,
Ricardo Tedim




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