I suppose the problem you could have with forcing constraints is that they can behave differently on each RDBMS or have adverse effects on things like each servers QPE.
Be good to see the tech note.
N
Geoff Bowers wrote:
Robertson-Ravo, Neil (RX) wrote:
Is it deliberate that there are not constraints in the FarCry Database Schema? There are primary keys etc so theoretically there should be Relationships?
This is probably by design...just thought I would ask.
We don't enforce any constraints by default. However, depending on your application and the data it houses is might be worthwhile optimising the schema for better performance. In fact our DBA is working on a technote talking to exactly this issue.
We'll release it as soon as it's done.
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
