Subject Performance Question
Author Olaf Kluge

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?


Thank you and best regards.