Update User Titles slow?

[auto]

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?

[Mike Sullivan]

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.

[auto]

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.

[Mike Sullivan]

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:

		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:

"."lastpost = $lastpost[dateline]

And the trailing comma from this line:

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

[auto]

Yep, that did it.
Did all 80k users in less than a minute.
Thanks a lot Mike.

[Raptor]

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