The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Using indexes to speed up queries
Hello, i want to use indexes in mysql tables to speed up queries, can you give me the exact command to execute?
EDIT: found a command like this CREATE INDEX pagetext ON vb_post (pagetext); but when i execute it i get the following error: #1170 - BLOB/TEXT column 'pagetext' used in key specification without a key length This is happening only in pagetext field in the whole table, other fields can be indexed, how do i fix this? any help is appreciated |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|