Subject Re: [firebird-support] Performance Question
Author Josef Kokeš
> Hello everybody,
> we plan a web-Application with a firebird database. Now I have two
> options to prepare the data for the web-client (HTML…).
> Option A – a view – returns Data from all Users and the client selects
> itself
> Option B – a stored procedure with input parameters, the client gets
> only the matching records.
> What should be the better option?

A is usually faster and easier to modify to match new requirements.

B is probably safer, provided that the user doesn't have credentials of
the database owner.

Personally, I go with B, because I am way more concerned about the
security than the speed. But that's just my personal deformation, it may
not be valid for your case.