Thanks Rick, but the index that I use is activated so I can search
for duplicates.

As the loading goes, searching is getting slower.
My question : slowness is it due to index updates or to statistics
not up to date ? or both ?

Finally, as you suggest, I can deactivate and reactivate these
indices (primary keys) between files or groups of records (every
100000 for example).

Alexandre

--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...>
wrote:

>
> When you reactivate them their statistics will be recomputed. Be

sure

> to recompile your stored procedures to take advantage of the new
> information, if the stats have changed.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of amoradell
> Sent: Monday, April 03, 2006 3:43 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Performance with indices
>
> Hi,
>
> I have to load several thousands records in a database through text
> files of about 100000 records each.
>
> The records are put into several tables (about 20 with one exceding

10

> million records).
>
> For performance reasons, I must deactivate almost every index and

also

> triggers.
>
> I have only primary keys activated to avoid duplicates.
>
> I want to know if these indices on primary keys have their

statistics up

> to date or do I have to recompute them between each file to maintain
> good performance ?
>
> Thanks
>
> Alexandre
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item

on

> the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>