Pavel –

Thanks for the reply. I did the following:

a. have an external table with 1,000,000 rows.
b. have a real FB table with same structure as external, but empty

1. insert into... select from external table
24.828 seconds

2. delete all rows from FB table; commit
3. create index on FB table; commit
4. alter index inactive; commit
5. insert into... select from external table
1:41.359 seconds

then, just to make sure, ...

6. delete all rows from FB table; commit
7. drop index on FB table; commit
8. insert into... select from external table
23.015 seconds

This sure looks like the index is getting updated, but I am just looking in
from the outside.

Thanks.

Louis Kleiman


-----Original Message-----
From: Pavel Cisar [mailto:pcisar@...]
Sent: Thursday, April 10, 2003 4:11 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Index deactivitation does what?

Hi,

On 10 Apr 2003 at 11:58, Louis Kleiman wrote:

> When I deactivate an index before inserting lots of records with FB 1.5
Beta
> 4, I don't get the performance gain that I do when I drop the index.  Is
> this a WAD?  Why does the server still churn when reactivating the index
if
> (as it currently seems), the index is still being updated when it is
> inactive?

Are you sure, i.e. can you verify that deactivated index is still
maintained ? If so, it's a bug and should be fixed. But I have doubt that
it's the case.

Best regards
Pavel Cisar

See you at the First European Firebird Conference in May in Fulda,
Germany
http://www.firebird-conference.com

http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information




Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.