Please could you tell me how big sql tables are when people refer to them as small, medium and large? Preferably in terms of disk space or rows (each row in my table will contain a standard length job advert and 20 additional columns with an average of 8 characters)
Depends on what they have dealt with and what the system is like.
I've heard people talk about 100 MB databases being large.
If you're talking about a batch system then probably a million shortish rows is quite small - the sort of thing you can table scan. On a web based oltp system with a lot of clients the same table might be considered large and need to be handled carefully.
Nowadays a lot of databases are talked of in Terrabytes - tens of gigabytes is the sort of size that you don't worry too much about in capacity measurement.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
It's subjective, so it'll be based upon people's opinions only.
My opinion on sizes of tables:
Small -- in the megabytes...thousands of rows or less Medium -- in the high megabytes and low gigabytes...thousands and perhaps millions of rows Large -- double digit gigabytes up to half a terabyte maybe...millions of rows XL -- half a terabyte and beyond...billions of rows
It also depends on the width of the table though. You could have millions of rows in a narrow table, and it might be considered medium sized. If it were wider, then it might be considered large or greater.
table size definition - small/medium/large
Posted - 07/18/2006 : 19:48:20
