Re: FGAC and that 30%

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 16 Jul 2004 12:40:49 GMT
Message-ID: <l1QJc.58915$eO.9665@edtnps89>

robert wrote:

> did you ever find out where that 30% went? was it lack of indexing,
> or actual function execution? a bit of both?
>

One other possibility comes to mind - additional complexity.

A lot of people assume FGAC is a rewrite to select from an additional column, as in "where permission = 'Top Secret'". FGAC is not limited to that and can involve significant additional overhead if one is not careful. For example, you could use a list (IN,LIKE or BETWEEN processing), or base the selection on calculations.

/Hans Received on Fri Jul 16 2004 - 07:40:49 CDT