--- In firebird-support@yahoogroups.com, "Lee" <lee@d...> wrote:

> Some of our clients have 200 stores which could be 14,600,000 rows

added

> annually to a database.
> Can FB handle this kind of size?
>
> What is the largest number of rows in a table anyone seen?

Lee, 14,600,000 rows annually added to _database_ is'nt problem. To
one table - perhaps. AFAIR when large tables are discussed here and in
other NGs approx 10,000,000 are mentioned and people live with them
without large problems. Of course developer's freedom is limited on
such a tables - it is recommended to avoid low selective indices on
them, perform mass updates/deletes of such a tables in exclusive mode
deactivating indices to avoid performance degradation etc. Shortly -
garbage collection issues are more significant for large tables so we
should pay more attention to them. Largest table in my database is
4,000,000 and sometimes I encounter problem with sweep after delete
and re-insert 10% of this table in concurrently accessed database.
AFAU main problem for huge _databases_ is time required for
backup/restore. Seems in FB1.5 both this problems have less influence,
but they remains.

Best regards,
Alexander.