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.

 

Olaf