Search MySQL like?

0 like 0 dislike
62 views
Hello.

There is a table of the form:

ID | COUNT | DATA | DATE | TYPE | IP


Every day is added to the database about 500 thousand records.

How can I make a search on the field DATA fast and how much time will take to search such a huge database, after a week, a month?
by | 62 views

5 Answers

0 like 0 dislike
by
0 like 0 dislike
Why do You seek links? Maybe it's worth of links to allocate the information which will be searched and stored in a single field index on the field?
by
0 like 0 dislike
what data in the data?
by
0 like 0 dislike
speed will greatly depend on whether the field DATA index is created
by
0 like 0 dislike
The first thing to do for such a volume is to cut the table on any basis, because 500K records per day — a lot. I remember there was a table with 4 billion entries, then all entries from this table was very nerdy
Second, you did not explain what kind of data contained in the DATA. Can do fulltext (provide show create table). If the data is large enough, as pointed out in the first answer, the Sphinx
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
0 like 0 dislike
7 answers
110,608 questions
257,186 answers
0 comments
32,907 users