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 |
|
ZoneFX
Starting Member
17 Posts |
 Posted - 2007-05-09 : 10:21:23
|
| I have a database with a "large" table containing date based information Basically they're reservations. I've thought about creating a new table and adding any records from past years to this table. For the most part only current reservation need to be searchable, but in some circumstances it would be useful to be able to search through the archive too. so, my questions!!!Is 8,000 or so rows of data "large" and unwieldly in SQL terms?Would splitting this data into 2 tables - one small table for current and future reservations and one larger archive table then using a UNION SELECT query to make archive information seachable be a significant improvment on server resources/load or am I making the whole thing more complicated than it need be as 8,000 rows of data is nothing to worry about.............What did they say about a little bit of knowledge being a dangerous thing?Thanks in advance of any guidance to a neophyte!!? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-09 : 10:23:28
|
8 billion, and you might have to start worrying  No, 8,000 rows is nothing to worry about. Are you getting problems with query performance?Mark |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-09 : 10:31:19
|
| If you are not getting satisfactory performance, you need to look at how the queries are written. Often, tweaking query a bit results in huge performance improvement.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-09 : 10:58:55
|
| 8,000 records...that's funny.e4 d5 xd5 Nf6 |
|
|
|
ZoneFX
Starting Member
17 Posts |
Posted - 2007-05-09 : 11:54:49
|
| Performance isn't an issue at all. I'm new at this and things worked great with 10 records. I was just concerned that it might get a bit slow as the records mounted up, but we have a few years to go before we get to a billion or 2 records!! I can be guilty of over complicating things................ Or at least thinking I need to make things more complicated than they need be.Thanks for your reassurances!!! and I'm glad I made a blindman laugh!! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-09 : 12:42:30
|
| "I can be guilty of over complicating things"Nah, better to have asked the question that have a Live system slow to a crawl and need to be fixed in "emergency development" mode!Kristen |
|
|
|
|
|
|
|
|
To split or not to split