Sean,



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. I upped the size in the RTRIM definition to 32,767 from 255. Are
you suggesting that this would effect performance?



Hardy







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



Hardy,

> I'm not sure which version, but its at least version 2.0. If you need

a

> more precise answer, I can get this information.

You might want to try using the new (w/ FB v2.0) RTRIM definition

provided in the new ib_udf2.sql script.



The engine/UDF detection/handling of null values was updated in v2.0.



Our next step, in this quest, if the new UDF doesn't help; is to try

come up with the small size test case which can be posted to the project

tracker for investigation.





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



http://groups.yahoo.com/group/firebird-support/



Individual Email | Traditional



http://groups.yahoo.com/group/firebird-support/join

(Yahoo! ID required)



mailto:firebird-support-digest@yahoogroups.com

mailto:firebird-support-fullfeatured@yahoogroups.com



firebird-support-unsubscribe@yahoogroups.com



http://docs.yahoo.com/info/terms/




-----------------------------------------------------------------------------------
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]