On 12/24/2011 10:19 AM, Thomas Steinmaurer wrote:
>
>

...
>
> That's a problem with SPs in general.
>
"in general" with SPs on Firebird or in general on SQL DBs?

Is a future FB 2.5.x or 3.x version going to improve on this?
>
> Using a WHERE clause when calling
> a SP won't be able to use an index. You have to put that *into* the SP
> whenever possible.
>
You mean passing the where as an input parameter and then use it within
the SP?
>
>
> So, if you don't need a (complex) logic for returning a result set,
> you'd better use a view, because a view can use an index for a provided
> WHERE clause.
>
I tried to go the view route but couldn't make it work.

What this is all about is to "translation" enable certain tables and
certain columns in these tables, most often just the name and searchname
columns and be able to do a "where" on these columns and there are
"where" selects on the id plus langid.

Thanks
Werner


[Non-text portions of this message have been removed]