Re: Stored procedure lasts to long when called-Mysql
Thanks for reply, Peter
How can I replace that "where message LIKE" statement? What do you mean by WHERE message LIKE ... will be slow unless (i) there is an index on message and (ii) searchstring does not begin with a wildcard.
What should I put instead?
I'm assigned to solve this SP, but I had made a lot of research and found no answer.
I think the problem rely on:
WHILE startTime<=endTime DO
which basically tell the Sp when to stop.
Hope you can reply
Thank you
Daniel
Subject
Views
Written By
Posted
2680
March 13, 2013 08:12AM
1064
March 13, 2013 09:59AM
1124
March 13, 2013 10:04AM
1091
March 13, 2013 10:24AM
1130
March 13, 2013 10:50AM
1049
March 13, 2013 12:15PM
1542
March 12, 2013 07:16AM
1158
March 12, 2013 09:42AM
Re: Stored procedure lasts to long when called-Mysql
1008
March 12, 2013 10:00AM
1184
March 12, 2013 10:26AM
1065
March 12, 2013 02:35PM
1092
March 12, 2013 08:04PM
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.