Migrate 200 Million of rows

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 30 Jul 2003 09:44:56 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F89FFC@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: wizofoz2k_at_yahoo.com.au (Nuno Souto) [mailto:wizofoz2k_at_yahoo.com.au]

>> those are called "lossy" compression algorithms. JPG image
compressions
>> is an example. For data you need "lossless" algorithms. For obvious
reasons.

What I really like about lossless compressors is the fact that you can compress a file, then compress it again and again and again until you end up with a 1 KB file (roughly). This can be copied to a floppy and your entire database cold backup sent to whoever you like. No need for all that NFS stuff - just a few passes through the compressor program does the trick.

<GD&R>

:o)

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Jul 30 2003 - 03:44:56 CDT