Re: MySQL on RAQ4
Randy Davis wrote: I recently had to upgrade MySQL on my Cobalt RAQ4 to support some complicated Joins. Unfortunately this has disabled my ODBC connection for the Chilisoft ASP. Has anybody gone this can give me a hand? Thanks! http://pkg.nl.cobalt.com/ has a RaQ4 .pkg for MySQL 3.23.37 If you need 3.23.38, email me privately... I modified a copy of it to install 3.23.38 instead and I think I still have the .pkg for it around somewhere... - Shawn --- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext index search slower than search w/ no index
Does this seem to weird to anyone?
mysql SELECT count('') FROM emailarchive where match (sendername) against
('shawn') group by '';
+---+
| count('') |
+---+
| 13286 |
+---+
1 row in set (3.29 sec)
mysql SELECT count('') FROM emailarchive where sendername like '%shawn%'
group by '';
+---+
| count('') |
+---+
| 13286 |
+---+
1 row in set (1.96 sec)
The more matches there are in a fulltext index search, the slower it gets
until finally at about 7,000 matches it actually becomes SLOWER than a
search with *no* index.
That leads me to believe that it's caused by the relevancy/weighting
routines, which leads me into my question...
Is there a way to completely disable the relevancy/weighting routines in the
fulltext index queries? I would really like to know either way so I can
stop stressing about it. :-)
- Shawn
---
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858) 452-3696
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT relevancy
Couple problems here...
Have a database with 36,316 emails archived.
emailarchive.emailbody has a FULLTEXT index.
If I query on a term that exists in the majority of the emails, it returns 0
rows and takes an incredible amount of time.
mysql SELECT count('') FROM emailarchive where listnum = 1 and match
(emailbody) against ('shawn') group by'';
Empty set (7.19 sec)
The above query should return a total of 22,778.
mysql SELECT count('') FROM emailarchive where listnum = 1 and match
(emailbody) against ('mysql') group by'';
+---+
| count('') |
+---+
| 121 |
+---+
1 row in set (0.03 sec)
Change nothing but the word you are searching on and it's relatively fast
(although it gets slower the more instances is there are)
mysql SELECT count('') FROM emailarchive where listnum = 1 and match
(emailbody) against ('billing') group by'';
+---+
| count('') |
+---+
| 5062 |
+---+
1 row in set (1.43 sec)
The only thing I can think of is that the relevancy ranking causing both
problems (null set and speed problems) as it gets slower and slower the more
results there are until finally it just stops returning anything (maybe
there are so many the relevancy is zero?)
If that is the case, is there anyway to turn off the relevancy ranking
portion altogether or any suggestions to make it not so painfully slow? 7+
seconds for an indexed search on 36,000 records seems a little excessive
(the FileMaker database that we are upgrading from does the 'shawn' search
in 0.42 seconds and returns the correct results).
- Shawn
---
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858) 452-3696
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
