Sphinx Search

[TECK]

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.

[PSS]

Originally Posted by TECK

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.

TRUNCATE TABLE `PREFIX_word`;

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);

[TECK]

Thanks PSS for integrating Kron's MySQL optimizations.
What is the `th_search`? Is not a vBulletin field. Thanks.

[amcd]

Originally Posted by TECK

Thanks PSS for integrating Kron's MySQL optimizations.
What is the `th_search`? Is not a vBulletin field. Thanks.

that is just an index name. you can write anything there.

[orban]

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.

[ALanJay]

Sorry to hear you won't be posting here any more.

[TECK]

Originally Posted by orban

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.

Why am I not surprised... Today, I've got a 30 points infraction warning for expressing myself freely.
Check my blog for more details.

[BigSoccer Tech.]

Originally Posted by andrewkhunn

I'd really appreciate that code as well.

On another note, does anyone know if I can use Sphinx to power the similar threads search in vBulletin or will I still need to use the default engine for that. Any pointers here would be much appreciated.

Any ideas on this?

[BillP]

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.

[Zia]

Originally Posted by orban

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.

hello...really curious...any one can say..
whats wrong with orban & Orbans Hack (Plugin base templet cache) -the hack moved to graveyard & deleted ?