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 |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2008-08-21 : 01:04:35
|
| Dear Sir/Madam,I would like to ask, if i have just a single table and keep all type of transaction or separate it into different type transaction table. If my existing record exist millions.Kindly give me your opinion.Because i used different table then using join to get the record, it's seem very very slow to execute it even through i have indexex the unique field.Or can you provide me some material on designing database to get a faster performance if the recorset is more than millions.Thank you in advance & appreciate for your kindly reply.God Bless You.Regards,Michelle |
|
|
pootle_flump
1064 Posts |
Posted - 2008-08-21 : 06:06:41
|
| The first one. One strategy might be to partition the table and archive off historical data. Millions of records should not be a big deal but it all depends on the context. To be more specific we'd need to the table structures and query. |
 |
|
|
|
|
|
Re: Database Design Structure