Re: Stored procedure lasts to long when called-Mysql
First, tables with names determined at runtime are often, even usually, indicators of data design problems. What problem are you trying to solve with this inefficiency? Have you proved there is no feasible alternative? If you can get rid of that query, your problem may go away.
Second, ...WHERE message LIKE ... will be slow unless (i) there is an index on message and (ii) searchstring does not begin with a wildcard.
Subject
Views
Written By
Posted
2676
March 13, 2013 08:12AM
1063
March 13, 2013 09:59AM
1124
March 13, 2013 10:04AM
1090
March 13, 2013 10:24AM
1127
March 13, 2013 10:50AM
1047
March 13, 2013 12:15PM
1539
March 12, 2013 07:16AM
Re: Stored procedure lasts to long when called-Mysql
1156
March 12, 2013 09:42AM
1007
March 12, 2013 10:00AM
1184
March 12, 2013 10:26AM
1065
March 12, 2013 02:35PM
1091
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.