I added indexes to post.dateline, thread.lastpost and thread.lastposter.

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

ALTER TABLE `thread` ADD INDEX(`lastpost`);

ALTER TABLE `thread` ADD INDEX(`lastposter`);


How to un-done it in phpMyAdmin ?

[sql]ALTER TABLE `post` DROP INDEX(`dateline`);

ALTER TABLE `thread` DROP INDEX(`lastpost`);

ALTER TABLE `thread` DROP INDEX(`lastposter`);
[/sql]

Forgive this question from a clueless newbie, but phpmyadmin?

please don't bump old threads;)

phpmyadmin is a web based interface to manage mysql databases. It is included with most hosting packages and can be downloaded from sourceforge for installation on your own server too.

If you want to run queries in vB3, you can use the control panel if you turn on $canrunqueries for your userid in config.php.