Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 table size definition - small/medium/large

Author  Topic 

stubarny
Starting Member

2 Posts

Posted - 2006-07-18 : 19:48:20
Hi,

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)

Thanks for your help! :-)

Stu

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-18 : 20:01:41
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-18 : 20:09:23
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.

Tara Kizer
Go to Top of Page

stubarny
Starting Member

2 Posts

Posted - 2006-07-19 : 05:59:41
Thanks for the help guys
Go to Top of Page
   

- Advertisement -