January 5, 2007 at 9:15 am
hi,
i have a search table which truncated daily at night. the number of rows increase and reach 3-4 million by after noon. which becomes a bottleneck and the queries run slow because of that.
i insert the search data into this table based on the conditions selected by the user.
this is in a web based online application.
need to do something so that the size of the table does not increase so much and then too the functionality is not affected.
can you suggest / guide me how this can be achieved. if the 2-3 tables are used to insert data hour wise or some other way is it possible and how.
also would like to add the sp through which the data is inserted is having dynamic sql. I have the appropriate indexes also created on this table. I tried executing the sp and dig into the detail trace. the insert into the table keeps on deteriorating. also at times it shows a statement as "select statman(......) ....." in the trace which makes it all the more slow that is by more than 200%.
Any help in this matter will be appreciated.
Thanks and Regards,
Manuni
January 5, 2007 at 10:13 am
3-4M rows a day shouldn't be too bad. Are your quieries indexed? I'd start trying to optimize those, but don't make too many indexes with that many rows. 3-4 max.
January 5, 2007 at 11:31 am
I have a primary key and 1 index on that table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply