I was not aware that I had to revise the UDF source code. Does it need to
be changed? If so, where do I find the source code and what has to be
changed? Would not changing and recompiling the UDF source code for RTRIM
explain the quadrupled run time?

I'm not sure about the maximum size, but it is at least 7,000 bytes. Is
there any harm in declaring the function to support strings up to 32K?

Thanks,
Hardy


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Monday, October 15, 2007 3:17 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] RTRIM Overhead

> 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


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links




-----------------------------------------------------------------------------------
This message and contents are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you
have received this email in error please notify the system manager.

The original email message has been scanned for computer viruses.
-----------------------------------------------------------------------------------



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