Well, I think it's going to faster in adding (eg a bacth procedure that has
to update your database) during period of relative low amount of queries.
The reason is quite simple : the engine doesn't have to index the rows you
insert (that's done after every single insert). Personally I wouldn't use
this tecnique during normal use of the engine because it would generate
"dead" periods when you reactivate the index (it has to reindex the table).


Marco Ferretti

> -----Messaggio originale-----
> Da: Gerhardus Geldenhuis [SMTP:linuxmail@...]
> Inviato: martedì 19 giugno 2001 10.05
> A: ib-support@yahoogroups.com
> Oggetto: RE: [ib-support] Speed of indexes
>
> Hi
> Why is it faster to update without indexes and then adding or activating
> them afterwards than by updating/adding with indexes active.
>
> Groete
> Gerhardus
>
> > -----Original Message-----
> > From: Helen Borrie [mailto:helebor@...]
> > Sent: 18 June 2001 16:58
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] Speed of indexes
> >
> >
> > At 04:41 PM 18-06-01 +0200, you wrote:
> >
> > >Is there anyway to speed-up inserts with a table that has indexes?
> >
> > Yes: deactivate them.
> >
> >
> > >Btw All of my data is generated like this(value=random(x)). My
> > reasoning is
> > >that it won't matter whether a char field contains numbers or letters.
> >
> > The casting involved might introduce overhead in huge batches. Ann?
> >
> > -- HB
> >
> > All for Open and Open for All
> > InterBase Developer Initiative · http://www.interbase2000.org
> > _______________________________________________________
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>