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.