imp commit=n and rbs

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 29 Apr 2003 09:20:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7039C0F05@lnewton.leeds.lfs.co.uk>

Morning Joel,

>> 2.1 million rows * 18 = ?G?

I see your point :o)

>> compress=Y on export, table in single extent truncated, ignore=y.
Due
>> to previous performance issues, this table is explicitly as
>> defragmented and contiguous as possible.
I'm saying nothing !

>> Yes, I know _all about_ compress=Y,
>> and it is appropriate for the situation.).
:o)

>> [index creation] Well maybe, but more than 5 times the table size?
I'm tellin' ya, my
>> "something weird this way comes" light is flashing brightly.
Mine's just glowing dimly at the moment, but it does seem odd - how many indexes on this table though ?

>> [constraints] Hmmmm... need to check that, since this is a summary
file, I don't
>> think that should be at issue, but it is possible the 4GL that dinked
>> with it may have done something overly-friendly...
I've got a 4GL system called Uniface, but it only creates constraints and indexes that I tell it to !

>> but still, more than 5* the table size?
It does sound excessive.

I'd be interested to hear what you find out though.

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 Tue Apr 29 2003 - 03:20:30 CDT