> 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