MY first post had html in it where I posted my indexin that I am using.
URL UNIQUE 5451 URL expiresFlag INDEX 1 expiresFlag title FULLTEXT 1 title keywords body_1 FULLTEXT 1 body_1 body_2 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 08, 2005 11:13 AM To: Mysql Subject: Boolean searches When using the Boolean search capabilities, I am finding it terribly slow. Since I am sure MySql uses this on their own site. What version of MySql is the fastest at this 5.0? I am using the PHPMySearch and I really think he did fair job on the crawler part. I built an XML converter for the results so I can now crawl websites and output XML its just the search on even 5000 rows (20mb of data) is very slow. Indexing seems to done properly to support this. I played with tweaking the character settings of the FULLTEXT search took it to 5 tried it at 3 no luck. I just think it should be faster than it is. The default indexes are. Maybe his PHP is querying the database wrongly or is out of date. I am running 4.1.8 Mysql What would be a good example on how to query the db for bring back ranked results based on what it found? Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183
