Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Record limits
- Thread starter sylvain
- Start date
Hi Sylvain,
Theoretically, the record limit is 2 billion, while the table size limit is 2 Gigabytes. But in order to achieve 2 billion rows without execeeding 2 GBs, your records could only consist of 2 bytes each. And, I've yet to find a practical use for billions, or even millions, of 2-byte records. ;-)
If your maxing out around 15 million rows, then the problem is probably you've reached the 2 GB table size limit. By my calculations, your record length is approx. 135 bytes. You may need to further normalize your data, if possible. If not, try reading:
Jon Hawkins
Theoretically, the record limit is 2 billion, while the table size limit is 2 Gigabytes. But in order to achieve 2 billion rows without execeeding 2 GBs, your records could only consist of 2 bytes each. And, I've yet to find a practical use for billions, or even millions, of 2-byte records. ;-)
If your maxing out around 15 million rows, then the problem is probably you've reached the 2 GB table size limit. By my calculations, your record length is approx. 135 bytes. You may need to further normalize your data, if possible. If not, try reading:
Jon Hawkins
- Status
Similar threads
- Locked
- Question
