MySQL Forums
Forum List  »  Performance

Storing many small files to MySQL
Posted by: Patinya Sangiamchit
Date: March 29, 2009 02:27PM

I have many of small files store in complex directory, such as /data/2009/03/29/someid/data/detail.txt. (the directory structure is just to prevent too many files in single dir)

The files (about 100k-500k files) have size about 10k to 100kbytes. I'm thinking, will it be faster if I move these small files to MySQL and access via PK. Will MySQL give me lower access time than ext3 file system? (of course, mysql data file still in ext3 partition but i think it may be faster because os doesn't need to travel deep in directory?)

Thanks ;)

Options: ReplyQuote

Written By
Storing many small files to MySQL
March 29, 2009 02:27PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.