I'm currently writing an email application, it reads a pop box and stores the mail body on the file system.
Theres currently nearly 1 million files on the file system called EMAIL_ID.dat
EMAIL_ID being the same as the other details for that mail in the db.
The reason i chose the file system to store the mail body is because the mysql table was too big the other way. over 2gig and ORDER BY was very slow.
Anyone got any ideas on how i can search the file system quickly or if indeed it can be done better ?