Left out Swish-E as well: http://swish-e.org/ Also consider using the filesystem that grew out of nutch: http://lucene.apache.org/hadoop/ On Oct 23, 2006, at 2:36 PM, Joshua Zeidner wrote: > Josh, > > I left out Sphinx, which is a lesser known option: > > http://sphinxsearch.com/ > > -jmz > > On 10/23/06, Josh Coffman wrote: Hi, > > Anyone have an experience or opinions on full text indexing with > MySQL? We currently use MS SQL with full text indexing, and its a > pain. > We are preparing for our db to add tens of millions of rows soon; > currently those tables are in the 600,000 - 800,000 range. So its a > big jump. > This data is fed to us and reloaded nightly. This data is used by > websites, and traffic increases with time. > > I'm concerned about performance in general, especially in text > searches. In case the topic starts to come up, I'd like to have any > idea how MySQL > well would handle something like this. Or PostGre for that matter. > Any difference between running those DB's on linux versus Windows? > > Thanks > -j > > > > > > > > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > -- > .0000. communication. > .0001. development. > .0010. strategy. > .0100. appeal. > > JOSHUA M. ZEIDNER > IT Consultant > > ++power; ++perspective; ++possibilities; > ( 602 ) 490 8006 > jjzeidner@gmail.com > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change you mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss