Re: time attributable to FGAC rewrite

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Tue, 13 Jul 2004 22:53:38 GMT
Message-ID: <SJZIc.50774$eO.34630@edtnps89>

robert wrote:

> been looking through this group, and what docs i have, but can't
> find an estimate/definitive measure of how much (additional) time
> to execute an arbitrary query might be attributable to FGAC.
>

I don't think it's possible to guess as FGAC allows simple and complex rewrites. (You are asking specifcally for the increase in execute time.)

Try it by hand - measure the raw time for the query, then measure the time with a hand-rewritten query.

Then compare that measurement with the time & cost of a) bypassing the secured query and b) adding the security into ALL the front ends. Received on Tue Jul 13 2004 - 17:53:38 CDT