Christian Andersen wrote:

>
>
> Firebird performance issues.

> The reason we need the views is that we have row level security. We do
> this by having views like this.
>
> create view foobar as
> select *
> from t_foobar
> where credentials in (select credentials
> from user_credientials
> where user_credientials.user_id = current_user);

Have you considered a view like this - which will perform better in Firebird

create view foobar as
select t.* from t_foobar t
join user_credentials u on u.credentials = t.credentials
where u.user_id = current_user

>

For the web view, probably the stored procedure approach Adam suggested
is the best. In theory, the optimizer should integrate the view
selection criteria with the criteria from the outer query... as long as
the view doesn't include aggregates, groups, etc.

Regards,


Ann