Manually added a bunch of posts, cant find how to reset count on index page

[pattycake]

Originally Posted by Zachery

You also ran the rebuild forum counter too, right?

The import going slowly sounds like a MySQL tuning issue, more than anything else.

I tried the forum counter first, hoping it would do the trick because it was the fastest. No go... bummer. Then did the post count that took almost 5 hours, again no go. I have not tried the thread counter yet. What happens if i try it on a live site?

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

Originally Posted by RichieBoy67

5 million posts is a lot. The only time I ever had issues with the posts importing was due to very, very large posts and threads holding things up due to the packet size which I just needed to adjust.

If you updated the thread, posts and forum counters at the very least and cleared the cache it should work.

You wrote a program to import threads, posts, forums, etc? What forum script were you importing from? 11 minutes for 5 million posts seems very fast! On some of the larger forums I imported with Impex I ended up going to sleep and just let it run but that was mostly7 for attachments.

>You wrote a program to import threads, posts, forums, etc? What forum script were you importing from?

Forum was a very very old and heavily modified version of Invision Board (v 1.2)

Yep... wrote my own program. The only thing that remains to be converted is the PM's... have not figured out the table yet... what the heck is:
a:1:{s:2:"cc";a:1:{i:1642;s:9:"RacerX317";}}
a:1:{i:32;s:13:"bullardracing";}