The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Portal style page for vb3.8
Can anyone recommend an alternative portal style homepage for VB 3.8 that is not vbadvanced?
vbadvanced adds indexes to the post table which kills performance of mysql |
#2
|
||||
|
||||
I think you have a misunderstanding of how things work. Indexes improve the performance of the database by speeding up searches of tables when the conditions of searches use columns that have been indexed. For example a query of the post table for all posts by a particular user (i.e. userid column) is much faster if the userid column is indexed than if it isn't. The cost of indexing a column (or groups of columns) is that it takes up space. The one thing that is not a cost is performance.
|
#3
|
|||
|
|||
Quote:
MYSQL decides how to execute a query based on a few things, indexes is one and data size is another. It is very possible to add an index and degrade performnce because the MYSQL query planner decides to use the wrong, more inefficent Index. From memory, the index was on last_modified on the Post table. We have 13M posts and the MYSQL query planner did not like this at all. Also bear in mind that every new index on the POST table means slower inserts as MYSQL needs to update extra indexes. |
#4
|
||||
|
||||
Quote:
Quote:
Quote:
If you really don't like the index, just drop it through your myphpadmin and it won't interfere with anything else and you can still use vbadvanced. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|