Comment 10 for bug 485966
Revision history for this message
| Mikkel Kamstrup Erlandsen (kamstrup) wrote | #10 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
Let's revive this old bug, and get the code in a mergeable state. Would be a nice feature for 0.3.3.
I still think we should limit *-queries to prefix queries only. Without a full text index queries with * inter*sper*sed in the strings will require a full table scan and expensive string checking. With a log of 1M events this will *completely* take down a regular netbook for several minutes.
This will diminish the syntax to be ! as prefix and * as suffix and should simplify the code a bit... Prefix queries can use the index on the textual columns (at least they do so in most db systems i know).
I am not saying that full text querying is not useful - quite the contrary. I am saying that if we want to support full text querying then we should do it properly.