Subject | Re: [firebird-support] Re: SQL Performance help |
---|---|
Author | Robert martin |
Post date | 2006-11-06T00:28:02Z |
Adam wrote:
That would be a nice improvement. I might look at using this in the
near future :)
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
> Don't you wish there was an edit button sometimes.Yup
>
> Another possibility is if you parse your title within the storedNice !
> procedure. This will help in that end:
>
> http://www.fbtalk.net/viewtopic.php?id=238
>
> You would then change your stored procedure to contain a single input
> parameter (up to 32K, depends on your needs).
>
> >From inside your stored procedure, you would do something like:
>
> SELECT DISTINCT OPTEXT
> FROM SPLITTEXT(:BookTitle, ' ', '-, ''')
> INTO :AWORD
>
> This would allow you effectively an unlimited number of search words.
>
> Adam
>
>
>
>
That would be a nice improvement. I might look at using this in the
near future :)
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd