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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2003-05-29 : 15:23:01
|
| Hey all,I've got a fairly small (mostly INT's and DATETIME) table that I plan on having about 10 million row in over the next year or so. We will have about 100k rows per customer, plus about 100 rows per day after that. We do a TON of selects on this table. All of the inserts (both the first 100k and the 100 daily will be inserted during off peak hours. I'm pretty sure that our select statements will be fairly slow due to the volume of data in that table. I'm looking into horizontal partitioning the data, but I'd like to see if anyone has had an experience with such, and could give me some advice. I'm looking at this article on how to impliment it.http://www.sqlteam.com/item.asp?ItemID=684I can't provide the create table statements on this one. :(Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-29 : 15:39:57
|
| I would think 10 Million should be cake. No need to partition, just properly index.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-05-29 : 15:43:28
|
| I'm think I'm gonna run some tests and see how "badly" a 10 million and a 20 million row table runs.That's the only real way to know eh?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 15:46:00
|
| I was thinking 10 million wasn't a huge amount as well. Are the rows pretty wide? What is the average row size?Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-05-29 : 15:55:50
|
| The max row length is about 850 bytes. I'd say the average is about 600 bytes.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Table Design Question