C
ChUIMonster
Guest
You should be able to dump that tr_hist table faster than that. Shutdown the db server and try a binary dump like so: proutil dbName -C dump tr_hist -RO Also -- if you have (or can obtain) a recent dbanalys check to see which index is the smallest and try the binary dump using "-index" whatever that smallest index is. Using buffer-copy is sometimes helpful but if you are going between servers with -S you will also need to carefully tune the networking. Jumbo frames is a good first step. Your buffer-copy code is also important. For instance, you will benefit greatly from proper transaction "chunking" vs one record at a time commits. Using the implicit record creation might also be helpful. But the first thing I suggest is to return to the binary dump. Try it with a -RO connection. And then try -RO plus the smallest index on the table.
Continue reading...
Continue reading...