> martijn i really appreciate you telling me this because i myself have been

experimenting with FB but i was wondering about the performance between view
and SP. do you think it would be better then to rather than have a select
query in the SP to make a seperate view (with proper filtration), and then
call it from the SP or simply to call the view as required by an
application.

>

It depends on what you're doing really :-) It's just something you have
to take in account when doing your server side objects.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com