You can use the following methods to load and unload simple large objects, which contain TEXT or BYTE data:
When you use external tables to load and unload simple large objects, you gain the following performance advantages: The external table is integrated in the database server and bypasses the client-server connection. External tables enable the parallel processing of multiple data files on multiple coservers.
You can also use either DB-Access or ESQL/C statements to insert simple large objects, but these methods pass data through the client-server connection and might reduce performance.
Use external tables to insert or load many rows or columns of simple large objects at a time. Use DB-Access or ESQL/C only to insert a few rows or columns at a time.
The following sections describe how to use external tables to load and unload simple large objects. They include the following topics: