MySQL Forums :: Performance :: MySQL blob performance

Advanced Search

MySQL blob performance
Posted by: Yotam Aner ()
Date: June 01, 2009 12:36PM

Hi all,
I have a question about blob performance that I can't seem to find answer to:
I'm dessinging a db whice will have the following fetare:
1. The db will store pdf files ~6mb per file.
2. ~20,000 files on db.
3. Each row in db have 5 keys + the pdf file.
4. Each file will be requested ~2 times.
5. After file is stored on db he won't be changed.
6. There's huge importance for permissions (i.e. one can only watch is files).
7. ~4,000 users.

Do any one have a performence comparison bettwen storing the files on file system vs storing the files as blob on db?


Options: ReplyQuote

Subject Views Written By Posted
MySQL blob performance 6548 Yotam Aner 06/01/2009 12:36PM
Re: MySQL blob performance 3029 Rick James 06/01/2009 10:52PM
Re: MySQL blob performance 2500 Yotam Aner 06/01/2009 11:41PM

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.