Subject | External Tables |
---|---|
Author | Hardy Sherwood |
Post date | 2007-10-19T16:06:51Z |
I'd appreciate help on the use of external tables to load data into internal
tables.
1. I understand that external tables is the best way of loading large
quantities of data into internal tables. Is this correct? If not, what is
a better method?
2. It seems that most experienced Firebird users recommend that only
CHAR columns are defined in external tables. Are there problems with using
other column types?
3. Does it matter how big the external file is in terms of bytes of
data? Number of rows? Number of columns?
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.
-----------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
tables.
1. I understand that external tables is the best way of loading large
quantities of data into internal tables. Is this correct? If not, what is
a better method?
2. It seems that most experienced Firebird users recommend that only
CHAR columns are defined in external tables. Are there problems with using
other column types?
3. Does it matter how big the external file is in terms of bytes of
data? Number of rows? Number of columns?
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.
-----------------------------------------------------------------------------------
[Non-text portions of this message have been removed]