really confusing numbers.

[jonsidneyb]

How is it that I am past rebuilding 88,000 threads but my forum only shows that it has a little over 57,000

 

[jonsidneyb]

And it fails.

 

[RobParker]

Did you find out why? Been running my import for 12 hours and finally up to this stage and it's rebuilt 80,000+ threads, despite me only having 60,000

 

[Jake Bunce]

That's the difference between the row count and the range of thread_ids. There can be gaps in the ids. So I can have these thread_ids:

1,2,8,9,10

The rebuild will show up to the number 10 when it processes the batches. But I really only have 5 threads.

If the rebuild is failing then you can try a smaller or larger batch size.

 

[RobParker]

Cheers

It completed on something like 90,000.

Some more confusing numbers I imagine you know the answer to, any idea why when I look at the database in phpmyadmin, the number of records for some of the tables are negative (e.g. ~413,841)?

 

[Jake Bunce]

That's not a negative sign. That's a tilde which means the count is approximate, not exact.

http://xenforo.com/community/threads/phpmyadmin-row-count-changes-every-time-i-browse-xf_post.14180/

 

[RobParker]

Ah balls, I've been up all night and the font was so small it looked like a -

Cheers