looking for way of handle text search

[dewen]

Hi, all

We have a web based email system(LAMP). The header info of emails stored in database, while content and attachment in file system. I'm looking for a way of handling text search. It's ez to query the database for subject and address in header. How about the body in file system? Any idea is grealy appreciated

[devinemke]

Originally posted by dewen
The header info of emails stored in database, while content and attachment in file system.

why? why not store everything in the db. it would make searching much easier particularly in you use Full-Text Search Functions.

[dewen]

we tried with db, but the expanding size of body and attachment soon exceed the limit of mysql limit.

[dewen]

To make it clear, I think I'm looking for a better way of searching files for a string

Thanks