Re: Stored procedure lasts to long when called-Mysql
>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.
Subject
Views
Written By
Posted
2936
March 13, 2013 08:12AM
1178
March 13, 2013 09:59AM
1231
March 13, 2013 10:04AM
1217
March 13, 2013 10:24AM
1292
March 13, 2013 10:50AM
1148
March 13, 2013 12:15PM
1673
March 12, 2013 07:16AM
1280
March 12, 2013 09:42AM
1108
March 12, 2013 10:00AM
Re: Stored procedure lasts to long when called-Mysql
1271
March 12, 2013 10:26AM
1172
March 12, 2013 02:35PM
1198
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.