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

VS

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




rgds,
CC

Options: ReplyQuote


Subject
Views
Written By
Posted
1 blob table vs multiple blob tables
1300
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.