Informix ER has a number of ways to move data in replicates.
I was doing performance testing of transferring smartblob data from an old server to a new one. The target table was empty for this test. It was about 5gb composed of 100K sized smartblob records.
Logging Mode | cdr sync | cdr check repl |
Logging Off | 5:34 | 9:30 |
Logging On | Logical Log Rollback (DNF) | 9:54 |
Obviously having smartblob logging on for important data is the preferred way to do it. You *can* lose data with an engine crash if smartblob logging is off, even if the table itself is logged. However for copies, the fastest way may be with it disabled.