[Openinteract-dev] fetch_group and security

[<And...@Be...>]

Hey!

now that we have our first larger OI application running for a month or so (
a trouble ticket system ), we now look into optimizing it. What we found is,
that checking security of a larger result set takes a significant amount of
time - which is no suprize, really, but lead to looking into the SQL used. 

Right now, fetch_group works like this:

- read all records controlled by the where clause and the limit ( 1 query )
- check security on each record ( 1 query for each record, so maybe
thousands )
- return only those records, for which security fits ( return maybe only
10.. )

What I would like to discuss here, is if a join with sys_security wouldn`t
make sense here. 

Comments?

regards,

Andreas