As the others have said, DB fluff is more likely to be your problem. When
was the last backup with garbage collection? When was the last sweep? What V
of FB are you using? Does it persist if you do a backup and restore?

Indices do slow down inserts, updates and deletes, but only marginally per
index, therefore you would need many indices or have a very tight definition
of "slow".

1M records is fine as long as the size per column isn't too great or the
page size too small.

To help we would need:
1) the DBStats
2) Table structure
3) Method of insert (e.g. BDE TTABLE, does one insert, then closes the
TTABLE)
4) Definition of slow.

Cheers,

Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: www.jac2.co.uk
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088

- Come and see me at DCON2003 - 3 talks and a day of preconf training.
- Completed London Marathon 13/4/03 beating my PB by 30 seconds - only �500
short of sponsorship, so if you're feeling generous, throw money at me at
DCON (VICTA - For blind kids).



""M Patterson, Multinail"" <mpatterson@...> wrote in
message news:3EA60B3F.1000206@......

> Hi,
>
> I'm asking on behalf of a colleague. A customer has our factory management
> product running Firebird. It has started running much slower. The file

size has

> reached 400 MB after about a year of use.
>
> The questions we have are:
> Could the presence of indexes significantly slow down our import process?

It

> consists mainly of INSERTS to the large tables, with say 1 million

records.

>
> Could the size of the table (~1M recs) significantly affect the speed of
> returning records read by index?
>
> Would it be sensible to split the big table into smaller tables, and

either have

> duplication or do Union queries as needed?
>
> Would it be sensible to have separate databases?
>
> I expect people to say Need more info, what are the record structures,

show me

> the plan, etc. But I'm asking in general. What things do people do to

speed up

> otherwise well designed databases that start running slow? And I'm the

Firebird

> sponsor at our company, working on a different project now.
>
> Regards,
>
> Mark
>
>
>
> 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/
>
>