> I don't follow what you mean by "You might want to try using the new

(w/

> FB
> v2.0) RTRIM definition provided in the new ib_udf2.sql script." I am
> using FB v2.

Even though you are FB 2, you could be using the older RTRIM
definition...

I want to make sure you are using the correct definition.

> I upped the size in the RTRIM definition to 32,767 from 255. Are
> you suggesting that this would effect performance?

First, did you change the UDF source to handle the size change? (This
would mean compiling a new UDF)

Second, it is very likely that the change in size did affect
performance.

What is the size of the largest non-blob/memo field in your source file?

Do you really need a definition which allows for 32Kb for RTRIM?


Sean