MySQL Forums
Forum List  »  Stored Procedures

Re: Stored procedure lasts to long when called-Mysql
Posted by: Peter Brawley
Date: March 12, 2013 10:26AM

>I think the problem rely on:
>WHILE startTime<=endTime DO

Use time stubs to find out.

> What do you mean by WHERE message LIKE ... will be slow

Table lookup is slow. Index lookup is fast. Indexes can't be used for LIKE arguments that start with a wildcard.



Edited 1 time(s). Last edit at 03/12/2013 10:26AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
2663
March 13, 2013 08:12AM
1062
March 13, 2013 09:59AM
1121
March 13, 2013 10:04AM
1087
March 13, 2013 10:24AM
1124
March 13, 2013 10:50AM
1046
March 13, 2013 12:15PM
Re: Stored procedure lasts to long when called-Mysql
1179
March 12, 2013 10:26AM


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.