Was a long time ago now, but I don't recall any indexes being involved.

What about:
- constant file extending?;
- an ingres bug (last resort of the desperate).

Have to say, I'm happy to find I've been wrong!


-----Original Message-----
From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk]
Sent: 16 June 2005 08:26
To: Ball, David
Cc: info-ingres@cariboulake.com
Subject: RE: [Info-ingres] insert into heap!?


Hi David,

The insert into a heap should be very fast - no matter how big it
is. But the thing that could slow it down is a secondary index on the
table. The progressivly slower insert smacks of an ISAM secondary
index in overflow. The overflows on the ISAM would require
sequentially searching every overflow page. Hence the performance
you observed.

The subsequent modify to btree may have dropped the index, it
may have cleaned up the index. Given that the subsequent inserts
proceeded much faster and didn't degrade - my guess is that the index
was not persistent.

Martin Bowes
--
Random Farscape Quote #16:
John - I'd like to leave this planet the way I got here. Alive and single.



************************************************** ********************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.

If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).

postmaster@npower.com

************************************************** ********************




This e-mail is provided for general information purposes only and does not constitute investment or transactional advice. For the avoidance of doubt the contents of this email are subject to contract and will not constitute a legally binding contract.

The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it.

If you have received this e-mail in error, please notify postmaster@npower.com (UK 01384 275454) and delete it immediately from your system.

Neither Npower nor any of the other companies in the RWE Npower group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.
Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the RWE Npower group of companies.

************************************************** ********************