Hi All,
we have a large table having 60 lakhs and more data.so we are facing a problem when we are executing insert or update query.
as a result our DB is very slow and sometimes we are facing deadlock , so it is not updated correctly.
storage engine of this table is Inno DB.
we want to access this table by creating views of that table.we want to execute insert , update on that view except using the main table.
will it be a solution to overcome our problem and make our DB fast??
please help me.
Thanks!
we have a large table having 60 lakhs and more data.so we are facing a problem when we are executing insert or update query.
as a result our DB is very slow and sometimes we are facing deadlock , so it is not updated correctly.
storage engine of this table is Inno DB.
we want to access this table by creating views of that table.we want to execute insert , update on that view except using the main table.
will it be a solution to overcome our problem and make our DB fast??
please help me.
Thanks!