Reverse similar threads creation order

[squishi]

I have reversed the order, and told the query to only query thread smaller than startat.

PHP Code:

    $threads = $db->query_read("
        SELECT title, threadid
        FROM " . TABLE_PREFIX . "thread
        WHERE threadid >= " . $vbulletin->GPC['startat'] . "
        ORDER BY threadid
        LIMIT " . $vbulletin->GPC['perpage']
    ); 


The process still starts with the first thread.

--------------- Added [DATE]1252425524[/DATE] at [TIME]1252425524[/TIME] ---------------

Hmm, that's weird.
I can load misc.php, but as soon as I add the variables "&do=updatethread&startat=12345", I get a 404 error.

http://mydomain.com/forum/admincp/mi...&startat=40000 gives me a 404.
http://mydomain.com/forum/admincp/misc.php loads just fine.

Must be something in the htaccess file, I guess.

--------------- Added [DATE]1252425598[/DATE] at [TIME]1252425598[/TIME] ---------------

There should be a form field added to the maintenance page that lets you define the startat value.

[Lynne]

Your url should be misc.php?do=updatethread&startat=40000

The query you posted is the original query, so I'm not sure what changes you made to it.

[squishi]

Okay. The last link worked. I guess I will do it this way.
Thank you for your support.

--------------- Added [DATE]1252438206[/DATE] at [TIME]1252438206[/TIME] ---------------

Wow, the process is much faster than usual when I start it at 40,000.
It will only consider the posts that are older than id 40,000?
So it will not build the similar threads for older threads?
That's not good.

[Lynne]

Originally Posted by squishi

Wow, the process is much faster than usual when I start it at 40,000.
It will only consider the posts that are older than id 40,000?
So it will not build the similar threads for older threads?
That's not good.

It only rebuilds the threads that have an id greater than 40000 if you start at 40000.

I seriously don't get what you are trying to do. You either want to rebuild ALL the threads, or do don't. If you are going to rebuild them all, then it doesn't matter if you start at id 1 or you start with the last id - you still have to go through and rebuild them all.

[squishi]

Originally Posted by Lynne

I seriously don't get what you are trying to do. You either want to rebuild ALL the threads, or do don't. If you are going to rebuild them all, then it doesn't matter if you start at id 1 or you start with the last id - you still have to go through and rebuild them all.

I want to rebuild all of the threads.

And it does matter.
On my forum, rebuilding the similar threads takes over 24 hours.
And the process often just dies somewhere at 25,000 threads.
If I start at the end, I can rebuild the similar threads for those latest threads and do not have to worry about the process reaching the oldest threads.

[Lynne]

Well, if you want to start at the end, then like I said, I think you will have to completely recode that section of the page.

Why don't you want to just turn on the option to create the list of similar threads when the thread is created? Do you really get so many threads created a day where that is going to cause problems? It sounds like what you are trying to do (rebuilding the similar threads all the time) is much more server intensive than just having the option on.