Fastest export/import? ✓ Answered: green (solid confidence) — Art Kagel, the author of myexport/myimport, directly confirmed David's understanding that external-table mode (-E) makes sqlcmd and myonpload unnecessary for fastest export/import.

Advisory only.

Informix 12.10.FC12 Solaris 10 1/2013 I have been searching back posts, and I think I understand that the absolute fastest export/import is achieved by using Art's myexport and myimport with -E option (external tables). So, neither sqlcmd nor myonpload is necessary for this specific objective of achieving fastest export/import. For example: myexport <my_database> -E -m -p myimport <my_database> -E -m -U -p Do I understand correctly? I welcome being set straight if I am misunderstanding. Thank you. DG

David: I think that you've already figured this out, but, yes, you are correct. If you are only using external table exports & imports you do not need myonpload or sqlcmd only myschema.