Jump to content

Download: (TB) Database Optimizer

Featured Replies

Posted

File Name: (T31) Database Optimizer 2.0.0
File Submitter: tera

A very useful tool to have. Thank you :)

Hi useful indeed but if any way to set the time that run???

  • Author

Hi useful indeed but if any way to set the time that run???


The modification is a task, simply change the time when the task runs :)
  • 9 months later...

Upgrade to v3.2?

  • Author

Upgrade to v3.2?



I'll release a new version with some more options but the current version works just fine in 3.2 ;)

Great and thank you for the wonderful job of yours. Any ETA approx?

  • Author

Great and thank you for the wonderful job of yours. Any ETA approx?



No ETA right now, since it already works I'm focusing on all the other mods first.
  • 1 month later...

Couple of questions...

1. Is it necessary to turn the board off while optimizing?
2. How big is big (referring to Skip Topics & Posts table? option)?

  • Author

Couple of questions...



1. Is it necessary to turn the board off while optimizing?



If you want to optimize also posts and topics table try running manually an optimize query on the table alone from phpMyAdmin or another tool and see how much time it needs to complete, if the time is about a bunch of seconds (like 15-20 at max) you can safely leave the skip setting disabled.
  1. [*]With the board offline the optimization process is a bit faster because most of the tables are not accessed while in offline mode [*]There isn't really a good value.. it depends from the number of posts you have BUT also from your server configuration. I would already enable it around 100-150k posts thought.


Thank you :)

  • 6 months later...

Hi tera :)
does will work with 3.3?

  • 1 month later...
  • Author

Yes it works, the topic title didn't update properly with the file update and still has the T31 prefix, I'll update it manually.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.