Subject Re: [firebird-support] View slower than a select
Author PenWin
I "solved" the problem by using a stored procedure. Not an optimal solution,
that's for sure, but for this particular case, it works well enough (the
number of returned records will be small, probably no more than 20 or so).
It is something to think about for future views which might well return
hundreds or thousands of rows.

Pepak