Discussion Locked

Database size

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Could anybody advice me on the size capabilities of Databases (mainly Access and Oracle)?

4 replies

by jimkunkel

My experience with Access indicates that performance falls off with table size. We see degredations at binary 'milestones'; e.g., a noticeable change above 65536 records (64K) and a much more dramatic slowdown beyond 128K records. If your record count can be kept under 128K records per table, Access can be really convenient.

If you need to move to a more powerful db environment, think hard about the costs of Oracle and Micro$oft -- poor quality and expensive support and greater vulnerability to hackers.

We ported all our apps but one to postgreSQL and couldn't be happier. Great support from the community and a solid, easily administered system.

by cachitok

Oracle is designed to support very very big table, if a table grows to much you can partition the table and their indexes in different tablespaces in different physical disks.
( but you'll need the Enterprise option )
It has too several ways to backup online big database, for backuping independently tablespaces.

by vinnyk27

i would like to do research in databases & information system's plz guide me how to write proposal's
thank u
regard's
vinny

This discussion is closed to new replies.