Is there a max table size? 2

[Firelord84]

Hi all. I am going to be writing large amounts of images to a table and I was wondering if there is a max size that a table can be? Thanks in advance for your response.

--Firelord84

 

[Cagliostro]

Theoretically is a very big number, but practically there this number never is a limit. John Fill

ivfmd@mail.md

 

[Cagliostro]

Theoretically is a very big number, but practically there this number never is a limit. John Fill

ivfmd@mail.md

 

[rycamor]

Searching the online documentation is a good thing for basic questions like this. I did a search for "maximum table size" and came up with a page entitled "How Big MySQL Tables Can Be". (

http://www.mysql.com/doc/T/a/Table_size.html)

MySQL's table size for version 3.23 is limited by either 8 Terabytes, or by the maximum file size supported by the operating system, which is usually smaller than that. In short, if you are using Linux on x86, you may want to use the Reiser File System (reiserfs), since it doesn't have the 2GB or 4GB limit.

I would guess that if you are running Window NT or 2000, your maximum file size is somewhere in the terabytes range, but I'm not sure.

 

[thumbelina]

I have been doing some reading of my own and everything I have read sugests that storing images directly is not recomended. To store them you have to set the field to blob, which only supports text so you then have to convert your image back and forth between a text format to prevent corruption. It is instead recommended that in the table you store a link to where the image is on your harddrive or server or whatever. I know this is not exatcly what you asked but, if you do it this way you will be storing simple strings into your tables, so the max table size won't be as important. I hope you find this helpful.