Is there a record limit (or size) in table with BLOB?
834754Mar 31 2011 — edited Apr 1 2011Hi all,
I created a table to store some texts and one BLOB column to store different kinds of files (PDF, doc, zip, etc)
Usually, these files have around 1MB size each.
The table now have 100.000 records, but only 100 of them have files in BLOB field.
My goal is to fulfill all 100.000 records with files, but I'm afraid that the table could not hold it. I really don't know if there's a limit or something.
Will this table hold all 100 GB of data?
Thanks all!