1 GB data in MySQL

[hkucsis]

Hi,

I have many many html files (size in G😎 and I want to make the content of these files searchable. One way is to insert the content of all the files into MySQL and then use SQL to search. But I am worrying the performance since I will use "Text" and the size is more than 1 GB.....

Is there any better way to make these files searchable, say downloading a search engine...??

Thanks,
Michael

[the_Igel]

I haven't got any real experience with high volume databases, but I believe that full-text search should be very slow. You'd better install a search engine, as there's a lot of free ones on the Net. Besides, most of them do more or less use of html markup, so the search result would be more relevant, than with simple full-text searching.

[planetsim]

1GB strike. I never thought Mysql could take that much.

[the_Igel]

Why not? I believe a single LONGBLOB may contain few gigs, to leave aside a table or database.