MySQL Forums
Forum List  »  Full-Text Search

Scale question FTS, for planning purposes
Posted by: Mark Giaconia
Date: May 01, 2011 02:59PM

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.


Options: ReplyQuote

Written By
Scale question FTS, for planning purposes
May 01, 2011 02:59PM

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.