Forum OpenACS Q&A: integrity constraints and mysql

Collapse
Posted by Matthew Terenzio on
I came across this on MYSQL.com . The user comments are mine. Most of you know DB better than me. Would you agree with my comments? link to mysql.com
Collapse
Posted by Talli Somekh on
  • A properly written application will make sure (internally) that it is not violating referential integrity constraints before proceding with a query. Thus, additional checks on the database level will only slow down performance for such an application.

impressive. we really need to update "Why not MySQL"...

talli

Collapse
Posted by mark dalrymple on
I think that should be applied everywhere!  A properly written application will make sure (internally) that all memory addresses being used are not violating another program's address space.  Thus, memory protection at the OS level will only slow down performance for such an application.  Down with protected memory!!