Re: Full export

On Wed, 3 Jun 1998 12:38:24 GMT, Konstantin Kivi <konst_at_sirena.rinet.ru> wrote:
>Can somebody tell be sample export/import time
>for the database of 5-10 GB. I know it depends
>on the machine and OS but I just want to figure out
>if it at all possible in the reasonable time (1-5 houres).

It is possible, but can be quite impacted by row chaining and blocksize. My 12G takes about 45 Minutes, 20-30% row chaining, dual processor sparc ultra-2. I think the I/O is generally the limiting factor.

>
>We got 512 M ram, 4 200MHz Mips and
>striping actross 6 mirrored disks.
>
>
>
>--
>Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru
> aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org
>
>
>

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.