Web Development

Ask something
Question Locked

MySQL size limit

0 helpful
3 replies

by suzanne.chong

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,

I want to know if there is a size limit in terms of my SQL DB, especially when it comes to adding rows (records) into a table. I have a 2400 rows by 171 cols data set. Is that going to be a problem?

Please advice. Many thanks!

Suzanne

3 replies

by oh smeg

It depends if the version of SQL you are using is 32 or 64 Bit and what it is running on a desktop or a server.

The more RAM that the OS has to use the less likely you will be to run into problems and the same applies if it is 64 Bit not 32 Bit. 64 Bit applications can also handle more processes than a 32 Bit version of the same application.

Col

by tony hopkinson

Mysql's theoretical limit is 3398, could figure out whether you mean My SQL or MySQL though. :p

2400 rows isn't a problem, rows normally goes to terabtytes.

However from dba / developer perspective I'd view any table with 171 columns as a prime candidate for normalisation, or even denormalisation, it's very unwieldy, and too big for everyday use in my opinion.

This discussion is closed to new replies.