Mysql slow upadte
Hi,
I am updating a row in mysql and its taking about 3 to 4 sec table structure is :
mysql> desc rv_sms_log;
+---------------+--------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+-------+
| mobileno | varchar(15) | NO | MUL | | |
| date | timestamp | NO | | CURRENT_TIMESTAMP | |
| message | varchar(200) | YES | | NULL | |
| source | varchar(5) | YES | | NULL | |
| oadc | varchar(12) | YES | | NULL | |
| messagetype | varchar(15) | YES | | NULL | |
| messageurl | varchar(200) | YES | | NULL | |
| transactionId | varchar(100) | YES | | NULL | |
| msgid | varchar(50) | YES | UNI | NULL | |
| smscid | varchar(25) | YES | | NULL | |
| delivered | varchar(10) | YES | | NULL | |
| errcode | varchar(5) | YES | | NULL | |
+---------------+--------------+------+-----+-------------------+-------+
and update query is
update rv_sms_log rs set rs.delivered = ?, rs.errcode = ? where lower(rs.msgid) = ?
using prepared statement for update
Subject
Views
Written By
Posted
Mysql slow upadte
1789
April 30, 2012 06:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.