hi there

i have been asked to write a reporting application. im wondering how
best to use the firebird 1.5 database. the reports in question are all
subject to user selectable filters. the choices i can see are dynamic
sql or sp. i would prefer sp but i have a question first:

where ((:inputfilter is null) or (... = :inputfilter))

if i use this kind of statement in my SP to dynamically assign
optional filters does this mean the SP is not optimised?

also my list of filters for each report may grow in the future. so is
it better to do dynamic sql? but then again sp is more secure? any
help for me to arrive at a decision very mush appreciated.