The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#381
|
||||
|
||||
You are to fast for me.
I edited the previous reply. Could you be kind and post the queries? I never played before with indexes. Thanks. |
#382
|
|||
|
|||
Quote:
ALTER TABLE `PREFIX_post` DROP INDEX `title`; KRon's improvements are worth doing, too: ALTER TABLE `PREFIX_post` ADD INDEX `th_search` ( `threadid` , `visible` , `dateline` ) ALTER TABLE PREFIX_pmreceipt DROP KEY `userid` ALTER TABLE `PREFIX_pmreceipt` ADD KEY `userid` (`userid`, `readtime`); ALTER TABLE `PREFIX_post` DROP INDEX `userid` ALTER TABLE `PREFIX_post` ADD INDEX (userid, dateline); |
#383
|
||||
|
||||
Thanks PSS for integrating Kron's MySQL optimizations.
What is the `th_search`? Is not a vBulletin field. Thanks. |
#384
|
|||
|
|||
that is just an index name. you can write anything there.
|
#385
|
|||
|
|||
I'm leaving this place if somebody wants to take over this thread and keep the guide up to date feel free to do so it's on page 26 I think. Bye.
|
#386
|
|||
|
|||
Sorry to hear you won't be posting here any more.
|
#387
|
||||
|
||||
Quote:
Check my blog for more details. |
#388
|
|||
|
|||
Any ideas on this?
|
#389
|
|||
|
|||
I am having problems with my Sphinx search.
I set it up in a basic setting and it is working fine, with a 4-character minimum search. I used the settings and hacks to search.php as described earlier in this thread. Then I changed VBulletin to allow 3 character words and some exceptions for 2-letter words. I changed sphinx.conf to allow 2 letter words. I reindexed sphinx, and still can search only for 4+ character words. Some of the complicating factors: Web server is NOT the searchd server. I do my indexing and run searchd on one host, I run the web server on another host. Any ideas? I can search using "search" from the CLI and find the 3-letter hits, so I think it has something to do with the way sphinx is shoe-horned in to search.php. |
#390
|
||||
|
||||
Quote:
whats wrong with orban & Orbans Hack (Plugin base templet cache) -the hack moved to graveyard & deleted ? |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|