> The default Wordpress search system uses 'LIKE' queries to perform a > search. This is not very efficient, and implementing that on a large > Laconica install would be a Very Bad Idea(TM) performance-wise. I don't > think it's a very good idea on a Wordpress install either, the main > difference being that typically the number of posts in a Wordpress > database is several orders of magnitude smaller than the number of > notices in a Laconica database. > > Laconica uses fulltext search, which is far more efficient. Stopwords > don't stop or crash a search - they are words that are deliberately > excluded from the index. [...]
Fair enough. Evan said he (or an appointee) will be looking at the current search problems, which seems to be more[1] than just what I reported. > Another alternative is to use Sphinx for the searching, as documented > in the README. I believe this is what Identi.ca does. Unfortunately using yet another set of processes to run a search is not a viable option for me. [1] http://mail.laconi.ca/pipermail/laconica-dev/2009-March/001125.html -- David Collantes, System Administrator College of Business Administration University of Central Florida 407-823-3418 > -----Original Message----- > From: Ciaran Gultnieks [mailto:[email protected]] > Sent: Thursday, March 19, 2009 6:32 AM > To: David Collantes > Cc: [email protected] > Subject: Re: [Laconica-dev] Dev GIT check out and miscellaneous > > David Collantes wrote: > > On this one, I am not sure how Laconica does it's search, but using > > another PHP set of scripts as an example, WordPress, the search works > > just fine, using just the MySQL searching capabilities I believe. No > > stopwords will stop or crash a search on WordPress. Why not implement > > something similar on Laconica? > > The default Wordpress search system uses 'LIKE' queries to perform a > search. This is not very efficient, and implementing that on a large > Laconica install would be a Very Bad Idea(TM) performance-wise. I don't > think it's a very good idea on a Wordpress install either, the main > difference being that typically the number of posts in a Wordpress > database is several orders of magnitude smaller than the number of > notices in a Laconica database. > > Laconica uses fulltext search, which is far more efficient. Stopwords > don't stop or crash a search - they are words that are deliberately > excluded from the index. If you don't like the default set of words > (and who would?) then you can alter or disable them entirely, as Olof > Tjerngren pointed out in a previous mail to the list. > > Another alternative is to use Sphinx for the searching, as documented > in the README. I believe this is what Identi.ca does. > > Cheers, > > Ciaran _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
