asked
Insert operation pause while fetch data.
I Store Data in Table1 for 1 day in Table2 for week and in Table3 for One Month On every day at midnight 1 am I delete yesterday data from Table1, 7 days ago data from Table2 when month change I change month table table3 (table3_jan,table3_feb etc) I have set Non-index on all tables (column col2 and col4) Currently I have 30 GB data in table3_sept and on daily basis it goes increases data inserted rapidly in above 3 table Now when I fetch 15 days Data from Table3. all insert operation get pasued when query get execute then insert operation get resume. So my question is how to avoid that pause process Is their any wrong table structure I have created Kindly help me on high priority.Thanks
You can use With(nolock) Statement while selection. EG SELECT * FROM table1 WITH(NOLOCK)
I have one non-index on bigint and datetime column and one bigint column is primary key Yes I check execution plan their is no any missing index
18 People are following this question.
