Database performance side effects of huge inserts
843859Aug 30 2006 — edited Aug 30 2006All,
I know this might not be the right place to raise this question. Just thought any of you might have come across this in db programming.
I have a table in database in which there would be huge no. of insertions through out the day. The volume of insertions per day would be around 20000 rows. And there is no process other than this which would be querying this table.
My question is whether so many INSERTs on one table would affect in any way the performance of the whole database ?
Would this affect the response time of the processes working with other tables in the same database ?