mySQL and full text indexing

[Joshua Zeidner]

Josh,

I left out Sphinx, which is a lesser known option:

http://sphinxsearch.com/

-jmz

On 10/23/06, Josh Coffman <josh_coffman at yahoo.com> 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 at 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 at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20061023/0629d2d3/attachment.htm