Forums: osCommerce カスタマイズ (Thread #23268)

検索が遅い (2009-07-01 19:46 by Anonymous #44694)

お世話になります。

フォームからの商品検索(advanced_search_result.php)についてですが
商品数40000位になってから商品検索が遅く(5秒近く)なってきました。
ちなみにカテゴリや商品表示は高速に動作します。

mysqlのキャッシュサイズ等、色々と試してみたのですが
良い結果は得られませんでした。

なにか良い改善方法はありませんでしょうか?


Reply to #44694×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: 検索が遅い (2009-07-02 09:08 by Anonymous #44700)

search_in_descriptionを切れば
それなりに早くなると思うけど
like %keyword% で検索してるから
インデックスが効かない

つまり遅いのは仕方ない

osC全文検索で一番簡単なのは
sennaかなぁ?
Reply to #44694

Reply to #44700×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: 検索が遅い (2009-07-02 11:06 by Anonymous #44707)

お返事ありがとうございます。

sennaをインストールして
products_descriptionのproducts_descriptionに
fulltextインデックスを作成し
そのまま運用出来るのでしょうか?
それとも
advanced_search_result.php等、
各種検索を行っている部分の変更が必要になってくるのでしょうか?

初歩的な質問で申し訳ございません。
フォーラムの過去ログやインターネットを検索してみたのですが
oscommerce+sennaの情報が少なかったもので・・・


Reply to #44694

Reply to #44707×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: 検索が遅い (2009-07-02 16:31 by Anonymous #44720)

全文検索はmatch againstだから
likeそのままじゃ駄目かな

http://dev.mysql.com/doc/refman/4.1/ja/fulltext-search.html

catalog側はadvanced_search_result.phpを
2行くらい直すだけと思う
Reply to #44707

Reply to #44720×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

RE: 検索が遅い (2009-07-03 11:52 by Anonymous #44736)

お返事ありがとうございます。

なんとなくイメージ出来ました。
テスト環境を構築して試してみようと思います。
色々とありがとうございました。
Reply to #44694

Reply to #44736×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login