DeleteCascade on PostgreSQL

This is a multi-part message in MIME format...

------------=_1121265650-24448-188
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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




------------=_1121265650-24448-188
Content-Type: text/plain; name="message-footer.txt"
Content-Disposition: inline; filename="message-footer.txt"
Content-Transfer-Encoding: 8bit


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

------------=_1121265650-24448-188--