I have a nice big RAID. I want to know if anyone can point me in the right direction for a good way of programming php/mysql to search and store a large amount of text.

Should it be compressed and word indexed? I'm very good with sql and good with php. But I've not dealt with super huge databases with mysql and php, only mssql server.

Is an J2EE application server better to deal with something like this? If anyone knows of any good online examples of same apps with source that might get me started setting up a bench marking test, I would appreciate it!

Thanks.

I'm not really certain what your problem is? Do you have the database designed and want to know if MySQL is up to the expected load? Do you want to know how to store text efficiently on a database?

I really don't get it, so maybe some more specific details would help.