I am looking for an advice: I have let say 50 000 newspaper articles which represent all together more or less 1 Go of text. I would like to be able to look efficiently for articles containing a specific word. If I put each article as a row in a mySQL table, do you have an idea how long it would take on a regular PIII 800 to get the result of a like-request?

Thanks a lot for your help,