MySQL Forums
Forum List  »  Performance

1 blob table vs multiple blob tables
Posted by: charles candy
Date: January 08, 2016 01:03AM

Hi ,

I wonder in long term, will there be performance different if i put all image/document of my application in one blob table compare to divide into multiple blob table according to modules in the application.

in programming, have one blob table save alot of work while having multiple blob tables , will give me extra coding

The following example , which give better performance

Table_A , Table_B, Table_C, Table_D -> Table_img1


Table_A, Table_B -> Table_img1
Table_C, Table_D -> Table_img2


Options: ReplyQuote

Written By
1 blob table vs multiple blob tables
January 08, 2016 01:03AM

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.