> -----Original Message-----

> We have 3 or 4 tables which have gone over the 100,000,000
> mark. It still performs quite well.

Correction I just did counts on them

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