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 |
|
bpgupta
Yak Posting Veteran
75 Posts |
 Posted - 2007-07-02 : 02:27:34
|
| Hi All,I having tables with more than 10 million records. I facing problems with in reporting and while inserting new records to tables.Now i have to slove the issues of select and insert new records. Can i select the records while inserting new records in the same tables.If yes then what is best statement i can use to select the records.you can give solution on any tables examples.Thanks in advance.BPG |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-07-02 : 02:48:52
|
| You need to consider horizontal table partitioning to speed up the data insertion and retrieval. May be you can split up the data based on time factor - like historical data and current data. Of course, for this to be effective, you have to careful as to how to partition the data so that most of the queries can be satisfied by searching limited amount of the data.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-07-02 : 03:26:04
|
| Thanks your reply.But i wanted to change my query /SP on the existing table.What is best way to handle without doing horizontal partition of tables.Please suggest me .Thanks,BPG |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 11:49:09
|
| Use nolock hint in select statement if possible. |
|
|
|
|
|
|
how to handle Select and insert on big tables