Quote:
Originally Posted by freecartoonporn
i have around 5 mil records and i only need to search title which is varchar 255 .
why the fuck this shit has to be so difficult for dbms.,
|
You would probably be better off NOT using full text search and just using a like statement instead. Full text search has a lot of overhead to it that should not be needed for just a 255 char field.
Do some testing between full text search and using a like statement.
If you can, index the title too.
All strictly imho, of course.
.