Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

MySQL size limit

Locked

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

Topic

Clarifications

In reply to MySQL size limit

Clarifications

Too many variables to answer this question

In reply to MySQL size limit

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

No and yes

In reply to MySQL size limit

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.

[Author]

Replies