• Resolved 3Lancer

    (@3lancer)


    Hi,

    This plugin works fine, until you get to an extremely large database.

    Testing with 200,000 user accounts, orders, etc.

    I get a ‘Gateway Timeout – 504 error’, I believe this is due to PHP Timeout? Would there be any solutions limiting the amount processed at a single time or do I have to increase the timeout via server side?

    https://www.ads-software.com/plugins/rvg-optimize-database/

Viewing 1 replies (of 1 total)
  • Plugin Contributor cageehv

    (@cageehv)

    Hey 3Lancer,

    Yes, sounds like a PHP-timeout (which is 30 seconds per default)…

    For testing, you could put the following line of code at the beginning of my main plugin file (rvg-optimize-database.php):

    /********************************************************************************************
     *
     *	MAIN CLASS
     *
     ********************************************************************************************/
    set_time_limit ( 4 * 3600 );
    
    // CREATE INSTANCE
    global $odb_class;
    $odb_class = new OptimizeDatabase();

    If that works your provider should increase the time limit on the server.

    peace,
    Rolf

Viewing 1 replies (of 1 total)
  • The topic ‘Gateway Timeout 504’ is closed to new replies.