I'm loading a fairly large file into a Firebird database using external
tables. Many of the columns in the internal tables are defined as VARCHAR.
The corresponding columns in the external tables are defined as CHAR. The
data in the corresponding fields are null delimited if the length of the
character string is less than the defined length of the column.

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.

I'd appreciate if you'd let me know why calling RTRIM more than quadrupled
the run time?

Thanks,
Hardy


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