Hi,
I have run into a search speed problem and am not sure if it is my server config or some alterations I had been making in search.php. I added sidebar filters, but also had put some code to search categories and brands.
i did the dbtest.php from http://www.pricetapestry.com/node/72 and got the following results
MySQL Server Version: 5.1.56
Merchants: 146
Products: 1324433
Testing SELECT without full index scan:
0.0217730998993
Testing SELECT with full index scan:
3.94525098801
I wondered would you be able to take a look at my search.php or if you see any problem in the results of dbtest?
I am working on {link saved}, it is my old PT site that I have been rebuilding since last year there were some security problems on my server and I had to take down my sites and fix what was defaced and move to a new server. It is getting there and I have been trying to make some improvements, but at the moment access is restrcited by ip address until it is all working properly. If you like i can add your ip address so you can see what I mean about search speed.
Hi David, I just wanted to check that you received my search scripts ok on Tuesday. No rush at all, I just want to check my email got there. I am thinking that if there are no errors in the alterations I had made then I could use the search in progress pop up for longer searches, as mentioned in a post made yesterday.
Hello Clare,
Really sorry it looks like I didn't receive anything - please could you resend and I'll get straight onto it...
Cheers,
David.
--
PriceTapestry.com
Hi David, I have resent the files from a different email address this time so hopefully it will reach you. I hope that this time it gets there ok. There is no rush for this at all, so (if it arrives) whenever you get a chance is fine. I will check back here again later to see if it arrived ok this time.
Just following up for the benefit of others discovering this thread!
Being on a dedicated server with configuration control over MySQL (/etc/my.cnf) search speed in this case has been improved considerably by increasing the buffer sizes as discussed in the MySQL configuration discussion thread, but also by
a) reducing the MySQL full text index minimum word length to 2 characters by changing or adding (as required depending on whether or not the setting already exists):
[mysqld]
ft_min_word_len=2
[myisamchk]
ft_min_word_len=2...and b) removing the stop words check.
When reducing the full text index minimum word length, a corresponding change must be made in search.php, currently the following check is performed at line 179:
if (strlen($word) <= 3 || in_array(strtolower($word),$stopwords))...so for an ft_min_word_len of 2, and to ignore stopwords checking, REPLACE with just:
if (FALSE)Cheers,
David.
--
PriceTapestry.com
Hi Clare,
Sure - if you would like to email me your search.php and html/searchresults.php I'll check them over for you...
Cheers,
David.
--
PriceTapestry.com