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.
| Author |
Topic |
|
davidliv
Starting Member
45 Posts |
 Posted - 2003-12-09 : 22:27:54
|
| I have a table which contains 187 fields of which 60+ are int and bit data types.The table will hold a small number of records.. 200 - 600 at most.My application will be mainly updating fields on a regular basis, as opposed to creating/deleting records. Does anyone foresee an issues w/ this size of table?-david |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-09 : 22:35:10
|
| Other than the fact that a table with 187 is usually the symptom of a bad design, no you shouldn't have any problems with that size.Damian |
 |
|
|
davidliv
Starting Member
45 Posts |
Posted - 2003-12-09 : 22:42:50
|
I agree. I think I answered my own question and was just dreading the work of splitting into multiple tables. Case of an app gone out of control.-davidquote:
Originally posted by Merkin
Other than the fact that a table with 187 is usually the symptom of a bad design, no you shouldn't have any problems with that size.Damian
|
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-12-09 : 23:06:23
|
quote:
I think I answered my own question and was just dreading the work of splitting into multiple tables. Case of an app gone out of control
I'm dreading the SQL you will need to write to extract meaningful data from this table, and also the update statements you will need to write/maintain to work with this data... a one-time redesign can save you lots of headaches in the long run.- Jeff |
|
|
|
GreatInca
Posting Yak Master
102 Posts |
Posted - 2003-12-11 : 13:30:00
|
| My largest table is 523,887,389 rows and 21,012,463,616 bytes. It has 7 fields (5 bytes of tinyint/smallint, 2 int FKs, and a varchar(50)).****************************************Check out my pictures at http://www.pbase.com/GreatIncaCheck out my company's site!http://www.jobing.com (Market picker for first visit)http://phoenix.jobing.com (corporate home market if you don't live in a covered market) |
|
|
|
|
|
|
Large table design