> 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.

< Josef

Thank you!

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the main
(top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links