Re: Stored procedure applied but still extrem slow.
1) was this just a loop, with only this function?
2) Is there a lot of data in the tables?
3) what storage engine are you using
4) what output do you get when you explain your queries?
e.g. do:
EXPLAIN
select sum(amount) from reload where agentid=@Agent and compid=@Comp
\g
(dont do explain select..into - it hangs, bug 15463)
5) is your query cache on? see:
http://dev.mysql.com/doc/refman/5.0/en/query-cache.html
Subject
Views
Written By
Posted
3068
December 01, 2005 03:08PM
1367
December 01, 2005 04:16PM
1712
December 02, 2005 03:38AM
1672
December 02, 2005 05:13AM
1627
December 02, 2005 12:26PM
1705
December 02, 2005 09:42AM
1648
December 02, 2005 02:18PM
1664
December 03, 2005 10:03AM
1521
December 03, 2005 10:08AM
Re: Stored procedure applied but still extrem slow.
1656
December 03, 2005 01:52PM
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.