Hello, I have a very simple database design, but it does have lot of data.
its a table called "data", with 4 fields..
dataid, author, date and text.
dataid is set to medium int, author to tinyblob, date to timestamp and text to text.
I have 6,000 rows, each one with 1,000~9,000 words in text.
My query is simple:
"select * from data where text like '%string%'
and its going kinda slow...
its mysql, can anyone recommend me a way to redesign my database to make it faster, or a better sql query?
its a table called "data", with 4 fields..
dataid, author, date and text.
dataid is set to medium int, author to tinyblob, date to timestamp and text to text.
I have 6,000 rows, each one with 1,000~9,000 words in text.
My query is simple:
"select * from data where text like '%string%'
and its going kinda slow...
its mysql, can anyone recommend me a way to redesign my database to make it faster, or a better sql query?