Hi! I have a table not too big but with aprox. 5 millions of rows, this table must have 300 to 400 select per second. But also must have 10~20 delete/insert/update per second. So, I need to know if the insert/delete/update really affect the select performance and how to deal with it. The table structure is very simple: account_id integer (PK) service_id integer (PK) enabled char(1) The index created on this has the same 3 columns. Most of time the table has more insert or delete than update, when update occur the column changed is enabled; Thanks! |
