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!

 

 

Reply via email to