Scale question FTS, for planning purposes
Hello, I am new to MySql. I use MS SQL now with a table of approx 1 billion rows on a varchar(500) column of English sentences (<= 500 chars in each row) that have been split from documents. I am wondering if anyone out there has ever used a MySql, single column, FTI on a table of this size.
The use case is to automatically "content screen" the sentences with boolean queries to load a data warehouse. In MS SQL the queries look like this
select...where contains(ColumnOfText, 'this | that | "this thing" | "That Thing" ')
The | means "or" in MSSQL Contains.
Can I accomplish this reasonably fast in MySql on a table this size? Honestly doesn't have to be lightning fast, because users are not waiting for it, the FTI will be used in a process of screening text to load a data warehouse.
thanks
Subject
Views
Written By
Posted
Scale question FTS, for planning purposes
4546
May 01, 2011 02:59PM
2004
May 02, 2011 08:22PM
1670
July 11, 2011 03:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.