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 по дате отправления: