On March 4th, 2006 Michael Prichard (not verified) says:
This is definitely an interesting conversation. I am currently using MySQL InnoDB tables to store all types of blobs. I currently have one DB up to about 30GB (I will be working on compression next) and it is growing. The schema is setup up so that the metadata is not on the same table as the blobs so I only hit the blob table when I want to retrieve.
I like this setup because it is very portable and easy to implement as an application. BUT (there is always a but) I am wondering just how big can I go and will there be performance losses. I plan on these DB's growing to very large numbers.
Has anyone had real experience with this? How big have you gotten these databases and what issues did you see? Are you happy with the setup?
This is definitely an
This is definitely an interesting conversation. I am currently using MySQL InnoDB tables to store all types of blobs. I currently have one DB up to about 30GB (I will be working on compression next) and it is growing. The schema is setup up so that the metadata is not on the same table as the blobs so I only hit the blob table when I want to retrieve.
I like this setup because it is very portable and easy to implement as an application. BUT (there is always a but) I am wondering just how big can I go and will there be performance losses. I plan on these DB's growing to very large numbers.
Has anyone had real experience with this? How big have you gotten these databases and what issues did you see? Are you happy with the setup?
Thanks,
Michael