Web Development

Question

Gravatar
0 Votes
Locked

MySQL size limit

By suzanne.chong ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Too many variables to answer this question

by OH Smeg Moderator 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

gravatar
Collapse -

No and yes

by Tony Hopkinson In reply to MySQL size limit

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

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.

Back to Web Development Forum

Start or search

Related Discussions

Related Forums