Author Topic: update data may cost a long time  (Read 2761 times)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
update data may cost a long time
« on: March 14, 2012, 03:16:52 »
today i found qm can't show the report.After debug,i found it was a problem with mysql.A update query take a long time and update statement is ' update queuemetrics.queue_log set data1='12' where call_id='******' and verb='CONNECT' limit 1 '.But this statement usually execute very quick,what may cause it? *** was my call id

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: update data may cost a long time
« Reply #1 on: March 22, 2012, 11:38:51 »
Why do you do that? as this query does not run by index, it may take a long time indeed if the table is large.

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: update data may cost a long time
« Reply #2 on: March 24, 2012, 16:07:35 »
because i found i can't open qm report, so i want to debug it out

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: update data may cost a long time
« Reply #3 on: March 30, 2012, 18:08:40 »
Ok but then it is normal that it takes a long time :-)