Hi
Btw
Even after deactivating the indexes performance is still very bad.
I dont even get a 20% usage out of the service and it is the only real
service running. Could it perhaps have something to do with the size of the
database. It is now around 1.4gig It is a single file.

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/
>
>