On 09/03/12 21:02, Bartosz Dmytrak wrote:
Hi, It is not really unlimited (max 1GB):
Limit | Value |
---|
Maximum Database Size | Unlimited |
Maximum Table Size | 32 TB |
Maximum Row Size | 1.6 TB |
Maximum Field Size | 1 GB |
Maximum Rows per Table | Unlimited |
Maximum Columns per Table | 250 - 1600 depending on column types |
Maximum Indexes per Table | Unlimited |
I don't believe that the maximum number of indexes is unlimited. Just try creating an index for every permutation of 160 columns, which is about 4.71E284 different indexes. It is simply not possible to house a computer big enough on Earth, and probably the known Universe is too small - not to mention minor details, like that even 64 bit integers would be far too small... :-)
For practical purposes, I accept the statement - gracious aren't I???
You would have an incredibly slow database for updates and insertions way before you hit any practical limits on the number of indexes.
One gigabyte is more than enough to house the text of the biggest novel I have ever read - about 940 pages for 'Lorna Doone' (it was almost 50 years since I read it, so I might have misspelt the title).
Cheers,
Gavin