Announcement

Collapse
No announcement yet.

Update User Titles slow?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Update User Titles slow?

    I am running beta 5 and when I try to update user titles the process is slower than a turtle - only did 200 userids in 10 minutes.
    Is this normal?
    Webmaster
    http://www.AutomotiveForums.com

  • #2
    It appears that the way that function is named, it's slightly incorrect -- the function actually does it little bit more than user titles. It seems to update the last post time for each user, which seems to be where the speed issue is coming from.

    Comment


    • #3
      do you think this is something that will be looked into?
      With 80,000 members, I don't see how I could practically run this script as it will take days.
      Webmaster
      http://www.AutomotiveForums.com

      Comment


      • #4
        Well, aside from being named slightly incorrectly, it's not necessarily incorrect. All I can recommend at this time is removing the code to update the last post info from misc.php.

        That consists of:

        Code:
        		if ($lastpost = $DB_site->query_first("SELECT MAX(dateline) AS dateline FROM " . TABLE_PREFIX . "post WHERE userid = $user[userid]"))
        		{
        			$lastpost['dateline'] = intval($lastpost['dateline']);
        		}
        		else
        		{
        			$lastpost['dateline'] = 0;
        		}
        2 lines down, this portion of the line:

        Code:
        "."lastpost = $lastpost[dateline]
        And the trailing comma from this line:

        Code:
        			$sql = 'usertitle = \'' . addslashes($usertitle) . '\',';

        Comment


        • #5
          Yep, that did it.
          Did all 80k users in less than a minute.
          Thanks a lot Mike.
          Webmaster
          http://www.AutomotiveForums.com

          Comment


          • #6
            Im having the same problem with vb 3.8.1 PL1

            What can i edit to drop updating last posts - I just need usertitles

            Thanks
            Digital-Forums: www.digital-forums.com | CK3 Games: www.ck3.co.uk

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X