i am trying to create a search engine for a large listing site.
the search engine will search through 4 tables. each table being a
separate listing category.
I am debating on weather to use the mysql full text search (MATCH/
AGAINST)
or to create some custom setup without using the the full text.
i just want to know if the match/against is too "heavy" and only slow
down my application. If there are around 15 fields to search in each
table and there are 4 tables, thats 60 fields that have to be indexed
as full text search. would that add a lot of "weight" to the database?

any would be appreciated.
thanks,
gil

giloosh <giloosh99@gmail.com> wrote in news:1192198587.630119.252520
@i38g2000prf.googlegroups.com:

> i am trying to create a search engine for a large listing site.
> the search engine will search through 4 tables. each table being a
> separate listing category.
> I am debating on weather to use the mysql full text search (MATCH/
> AGAINST)
> or to create some custom setup without using the the full text.
> i just want to know if the match/against is too "heavy" and only slow
> down my application. If there are around 15 fields to search in each
> table and there are 4 tables, thats 60 fields that have to be indexed
> as full text search. would that add a lot of "weight" to the database?
>
> any would be appreciated.
> thanks,
> gil

Try reading through the comments at
http://dev.mysql.com/doc/refman/5.0/...xt-search.html

There are lots of tips and comments related to what you're asking.