Re: [Openinteract-dev] fetch_group and security

[Chris W. <ch...@cw...>]

* Andreas Nolte (And...@Be...) [011128 03:04]:
> Hi Chris,
> 
> it took me a while to find out, why I exactly do not see this as the
> solution to all performance issues.
> 
> The problem arises, when you have a larger system ( right now we have
> 161.000 records in sys_security... ) and use ( maybe misuse ;-) ) the
> security system to provide for a multi client system where sys_security sort
> of works like some client row in a table.
> 
> In this setup you have queries, which return a larger result which gets
> boiled down within the security system to return only the records of one
> client. Therefore most fetches waste quite a lot of resources. Same thing
> with fetch_count...
> 
> What we will try is using sys_security whith skip_security like this:
> 
> call fetch_group with a join of the data table to sys_security on the
> relevant queries.
> 
> We hope, that this does it - more later.

Great! I'm very curious to hear the effects this has. Thanks for
braving the waters :-)

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.