krislioe_at_gmail.com wrote:
> Another question, will it be any case that applying VPD will improve
> performance ?
Well, yes and no. It narrows the results so it is perfectly possible. But on
the other hand it's not like you can't get the same performance without
VPD, because obviously you can just put the predicates directly in the
query. You eliminate the VPD mechanics impact but give up security, because
you become prone to information disclosure in case somebody finds a way to
query your database behind your back (eg. sql-injection).
So the performance improvment would involve functional change because if you
run the same query with and without VPD then it should be (marginally)
faster without it. But if you currently have some queries that return
unnecessary data, VPD can impact the results and therefore performance.
--
Michal Kuratczyk
Received on Thu Aug 17 2006 - 10:09:40 CDT
