| Subject | RE: [firebird-support] FB Size Limitations/Performance Questions |
|---|---|
| Author | Andre du Plessis |
| Post date | 2003-10-15T06:33:09Z |
Thank you george for the swift reply, although I never thought that
firebird/ib would have a problem storing millions/billions of records and
still fetch specific ones in a couple of milliseconds,
however my problem here has nothing to do with the amount of records, we
have over 100 fields in the table, there are MANY indexes probably more than
50, selecting a specific record based on the PK is really slow, so I was
wondering if the problem has anything to do with too many fields and/or too
many indexes.
We already have done sweeps/backup/restore to try and clean up any garbage
from the table(s).
This table performs SLOW even with very little data.
-----Original Message-----
From: George P Boutwell [mailto:gboutwel@...]
Sent: Tuesday, October 14, 2003 6:46 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FB Size Limitations/Performance Questions
Table A is at 2,330,200
Table B is at 4,988,050
Table C is at 4,825,210
For the record we run a dual-processor 600Mhz Win2k Machine with 2
Gigs of RAM. On average we have 100 or so users concurrently accessing
this DB, and at peak times it's 300 users concurrently accessing this
DB. Performance has always been good for our application(s), when we
start to have performance issues we typically upgrade the Server
Machine, but we've only done that 1 time so far (althought I'll say that
we are looking to upgrade it now). Also, this DB has been in operation
with the first 2 tables for over 5 years (the last table was added
recently).
HTH,
George
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
firebird/ib would have a problem storing millions/billions of records and
still fetch specific ones in a couple of milliseconds,
however my problem here has nothing to do with the amount of records, we
have over 100 fields in the table, there are MANY indexes probably more than
50, selecting a specific record based on the PK is really slow, so I was
wondering if the problem has anything to do with too many fields and/or too
many indexes.
We already have done sweeps/backup/restore to try and clean up any garbage
from the table(s).
This table performs SLOW even with very little data.
-----Original Message-----
From: George P Boutwell [mailto:gboutwel@...]
Sent: Tuesday, October 14, 2003 6:46 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FB Size Limitations/Performance Questions
> -----Original Message-----Correction I just did counts on them
> We have 3 or 4 tables which have gone over the 100,000,000
> mark. It still performs quite well.
Table A is at 2,330,200
Table B is at 4,988,050
Table C is at 4,825,210
For the record we run a dual-processor 600Mhz Win2k Machine with 2
Gigs of RAM. On average we have 100 or so users concurrently accessing
this DB, and at peak times it's 300 users concurrently accessing this
DB. Performance has always been good for our application(s), when we
start to have performance issues we typically upgrade the Server
Machine, but we've only done that 1 time so far (althought I'll say that
we are looking to upgrade it now). Also, this DB has been in operation
with the first 2 tables for over 5 years (the last table was added
recently).
HTH,
George
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/