Questions about Database size

  • Hello,

    I’m going to set up a site build in WordPress for a client. As it is an e-commerce, we will be working with a catalog wich will be balanced between 8.000 – 10.000 entries.

    The most part of the times, every single.php load will be calling for a main post, some asides, some related posts lists, and a contact form, but beyond that, it is not expected to be something much more sophisticated.

    The traffic will be quite moderated if the pronostics are accurate, say 100 visitors a day.

    So, my question is : will a catalog sized like that slow down the site ? Should I worry about it ?

    And, then :
    Once we have done the catalog, which is projected to be done via browser and web editor, I’ll do regular backups of the database, just to prevent.

    If ever something goes wrong, do I need special knowledges to rebuild the database ? I’ve heard the maximum size to transfer via browser is 2MB, which I think it will be not enough for me.

    And that’s all. Thank you for all your suggestions, I need this general orientation because my professional formation is not in computers and I prefer to go sure through this adventure ??

    Happy holiday season all,

Viewing 5 replies - 1 through 5 (of 5 total)

  • Regarding the 2MB, that is set by your PHP ini file with the max upload and max post sizes, so it could be increased if needed.

    I think WordPress will generally scale to match your site. A couple of menu pages may be a bit slow with many thousands of posts, but this does depend on your hardware also.

    Thread Starter dunkkan

    (@dunkkan)

    Hello mrmist, thanks for the reply. However, where do I find the php.ini ? I know I have one in my local WAMP installation, but don’t know if that have something to do.

    By the way I’ve read that you cannot upload a big database by ftp, because the ftp ‘interacts’ with it. What does that means ?

    Could I avoid that – and make the import internally in the server, after the upload ?

    I’ve been reading the Cache docs too, and it seems like WP can resist quite well a catalog. ??

    Thanks for the feedback.

    To find out where the PHP.INI file is currently located, create a info.php file with the following code:

    <?php phpinfo(); ?>

    Place the file in the same directory as your WordPress files.

    Then, in your browser, go to https://<whatever>/info.php

    It will then spew out the PHP configuration and variables. Look for Loaded Configuration File near the top to see where the PHP.INI file is located that it is using.

    Depending on the webhost, you can put your own copy of PHP.INI into the same directory as your WordPress files and it will use that copy instead.

    You might look at SQLyog, https://www.webyog.com/en/ for working with your MySQL databases. It has the ability to backup and restore databases. I happen to use the Enterprise version which allows for Scheduled Backups.. I back-up my blog and gallery databases nightly using this. In any event, the free version is much better than trying to deal with phpMyAdmin which I hate LOL.

    Thread Starter dunkkan

    (@dunkkan)

    Thanks guys for all the answers, I’ll try it out.

    AQLyog is the superior app, but phpMyAdmin can do the job of importing/exporting in a bind (although large imports may have to be segmented).

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Questions about Database size’ is closed to new replies.