It shouldn't be a big surprise that it is slower, after all the stored
procedure gets two values in one select, whereas the query needs two
subselects to do the same thing. I am a bit surprised that the
difference is that big, though, especially since it does not use any
index.

> Query:
> stored procedure:
> Query Time
> ------------------------------------------------
> Prepare : 15
> Execute : 172
> Avg fetch time: 172.00 ms
>
> Query Time
> ------------------------------------------------
> Prepare : 15
> Execute : 94
> Avg fetch time: 94.00 ms

Set
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation