• Creator
  • #2148294

    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!


All Answers

  • Author
    • #2565598


      by suzanne.chong ·

      In reply to MySQL size limit


    • #2565571

      Too many variables to answer this question

      by oh smeg ·

      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.


    • #2567274

      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. :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.

Viewing 2 reply threads