I Can't Believe the Difference in Speed

[Xenon]

cinq, everything is exactly mentioned here, i posted the downsides 3 posts above.

[cinq]

Dbspace ie. the database just gets bigger right ?
Will the increase be so substantial that it is something to worry about ?

So the command i use in phpmyadmin is run this query ?

ALTER TABLE `post` ADD INDEX(`dateline`);

Just wish to confirm and not do something wrong and foul up the board

Thanks

[Dolby]

Since it can be un-done ( looks like you just go into phpmyadmin and click on the drop button where it lists the indexs) I tried it and vbstats show some increase in speed. I was at about "Page generated in .8xxx" and its now about "Page generated in .06xxx" on my forum index.

Currently have 112 online browseing.

[okrogius]

Downsize to too much indexes is not just extra database space. While adding an index to thread.lastpost speeds up Get New Posts, it also slows down New Thread/Reply.

[Dolby]

Hmmm seems just as fast if not faster on my busy board to make a new thread or reply. *shrug*

[Erwin]

Downsize to too much indexes is not just extra database space. While adding an index to thread.lastpost speeds up Get New Posts, it also slows down New Thread/Reply.

As most of the database load is from guests browsing the forums, rather than posting, the trade-off is well worth it.

[TTG]

I added the ALTER TABLE `post` ADD INDEX(`dateline`); and must admit my board seem to load a lot faster.

What are the codes to add for post.dateline, thread.lastpost as well as thread.lastposter

[chris2707]

Can this be done with the board open and users using the vB?

[Xenon]

yes

[RichieBoy67]

Great Tip! Amazing speedup!!!

Thanks-- I just did this to both my sites and it is awesome and so dam simple...