XF 2.2 ACP 2.2 Upgrade Suggested Limits?

[Rhody]

Is there a suggested size limit for ACP upgrades to 2.2?

Have about 8500 users and 1.1 million messages on one of my forums. Is that still within the limits, or should I be doing it by command line method?

I hear folks mentioning timeouts, and don't want to have to do this twice

Thanks

 

[Paul B]

The upgrader will prompt you to use the CLI upgrader if the site is large.

I believe it's 500k or more posts or 50k or more members.

Edit: Yup.

public function isCliRecommended()
{
    if (!$this->isSignificantUpgrade())
    {
        return false;
    }

    $totals = $this->app->db()->fetchOne("
            SELECT data_value
            FROM xf_data_registry
            WHERE data_key IN ('boardTotals', 'forumStatistics')
            LIMIT 1
        ");
    if (!$totals)
    {
        return false;
    }

    $totals = @unserialize($totals);
    if (!$totals)
    {
        return false;
    }

    if (!empty($totals['messages']) && $totals['messages'] >= 500000)
    {
        return true;
    }

    if (!empty($totals['users']) && $totals['users'] >= 50000)
    {
        return true;
    }

    return false;
}

However, it's really only crucial if there are alters on some of the larger tables, such as xf_post, which there is for 2.2.

 

[Rhody]

Thank you. Better safe than sorry, will do CLI version.

 

[Rhody]

Actually, I'm glad to report that it worked flawlessly with the ACP upgrade, with 1.1 million posts and 8500 users. I had a fresh backup, was feeling brave at 4am, and decided to give it a try this morning. Our live system is now on 2.2

I guess the speed of the hosting company also plays a major role in the outcome.

 

[duderuud]

I always run the cli (210k users, 30mln posts) and the upgrade took about 10 minutes.

And @Rhody is right. Upgrade duration is of course dependant on server hardware. With a lot of memory, fast processors and fast ssd's it will take much less time compared to a small cheap server/vps.