| ||
Sat 2025-02-22
Wed 2025-02-19
Tue 2025-02-18
Sun 2025-02-16
Sat 2025-02-15
Fri 2025-02-14
Thu 2025-02-13
Wed 2025-02-12
Sun 2025-02-09
Fri 2025-02-07
David Hockney's A Rake's Progress Thu 2025-02-06
Wed 2025-02-05
Search
Archives
2024
12 11 10 09 08 07 06 05 04 03 02 01
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
One good site
MDN
Nelson Minar
Blog licensed under a Creative Commons License
|
Today's project was to index my 100,000 email and Usenet messages into a
MySQL
full text index
so I can search things I've written. Not bad: 15 minutes to parse
and load the messages, 5 minutes to build the index. Queries
take a tenth of a second or two. MySQL supports a rich boolean query language.
What I like best is how easy this was. I spent weeks building Funes, a Java mail search program that never was useful. With Python and MySQL it took me just a few hours and the result is better! Goodbye, grepmail. I'm not the only MySQL fulltext enthusiast: Jeremy Zawodny's blog has a great entry with comments and Mitchell Harper has a useful introduction article. There's also some performance discussion on a PHP forum. One trick - for speed, run myisamchk -a on the table after building the full text index. And do your big load before creating the index; afterwards, inserts are slow. |
|
