Re: Export times: affected by size of table or amount of data?

In article <37666778.A1AEDB4A_at_si.unirioja.es>, Julio Negueruela <julio.negueruela_at_si.unirioja.es> writes
>Andy Hardy escribió:
>>
>> Hi,
>>
>> If I declare a 100Mb table with no data, will it export in less time
>> than the same table full of data?
>>
>> I thought that export times were only dependent on the quantity of data
>> stored, but my customer is telling me otherwise...
>
>I suppose you mean a table with a extent of 100 Mb.

Yes.

>If you export a table without exporting the data (rows=n) you only dump
>to the file the table creation statement, so it will be much faster than
>exporting the statement and rows, won't it? This way, if you export a
>table without any row, you only dump the creation statement, too.

Sounds reasonable to me! Thanks,

--
Andy Hardy. PGP key available on request