This table had 4 rows because we cleared all the data in a test DB to test
the speed.
In production it will grow to PLENTY. (expect about 7 or 800000 per year
depending on the client)

I understand what you are saying completely, but the table must carry lot’s
of de-normalized data for 2 reasons, first of all auditing, and second of
all to make use of SQL providers, they don’t work with multiple tables, I
know this is not the best of design however all redundant data is kept on
this record as an audit trail

Please help me with our speed problem

Thank you.

_____

From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, October 15, 2003 8:58 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FB Size Limitations/Performance Questions

At 08:33 AM 15/10/2003 +0200, you wrote:

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

Didn't you say this table has only four records? if so, DROP ALL THE
INDEXES.

Even better, change the geometry of the data structure. 100 rows of 4
columns, plus a PK and maybe a couple for types or groups, would be much
faster than 4 rows of 100 columns. In future, you would add a new row
instead of a new column...it's called future-proofing. :-) No indexes
needed on a table of 100 rows.

heLen






Yahoo! Groups Sponsor


<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17051153
86:HM/A=1524963/R=0/SIG=12o885gmo/*http:/hits.411web.com/cgi-bin/autoredir?c
amp=556&lineid=3614674∝=egroupweb&pos=HM>


<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=732920344>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]