Re: constraints and performance
От | Christopher Browne |
---|---|
Тема | Re: constraints and performance |
Дата | |
Msg-id | m3smhh7ls9.fsf@wolfe.cbbrowne.com обсуждение исходный текст |
Ответ на | constraints and performance (Jodi Kanter <jkanter@virginia.edu>) |
Ответы |
Re: constraints and performance
|
Список | pgsql-admin |
A long time ago, in a galaxy far, far away, jkanter@virginia.edu (Jodi Kanter) wrote: > Do constraints effect performance significantly? They would be expected to provide a significant enhancement to performance over: a) Firing triggers, b) Firing rules, and c) Forcing the application to validate the data, and then adding in "data validation" reports to report on the cases where a buggy application violated the constraints. So yes, they should be considerably faster than any of their alternatives. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','ntlug.org'). http://cbbrowne.com/info/lsf.html "The only constructive theory connecting neuroscience and psychology will arise from the study of software." -- Alan Perlis [To the endless aggravation of both disciplines. Ed.]
В списке pgsql-admin по дате отправления: