Sean,



To add the rtrim function I revised the statement

insert into internalTable (col1, col2, ...) select field1, field2, ... from
externalTable

to

insert into internalTable (col1, col2, ...) select rtrim(field1),
rtrim(field2), ... from externalTable

for those columns which are defined as varchar in the internal table.



I declared the rtrim function with the statement

declare external function rtrim cstring(32767) returns cstring(32767)
free_it entry_point 'IB_UDF_rtrim' module_name 'ib_udf'



Thanks,

Hardy





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

> The run time before I added a call to RTRIM for each of the VARCHAR

fields

> was about 13 hours. After adding the call to RTRIM, but making no

other

> changes, the run time jumped to about 64 hours.

How did you add the RTRIM call?





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]