MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Why this is slow ?
Posted by: hello world
Date: December 02, 2005 03:38AM

hi, roland

reload table has a
-index agentid_compid (agentid,compid);

payment table has a
-index agentid_compid (agentid,compid);

cdr table has a
-index agentid_compid (agentid,compid);


tables data types:
-agentid varchar(3) not null default ''
-compid varchar(100) not null default ''

agentid, compid cant be only numeric its always string type.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Why this is slow ?
3070
hello world
December 01, 2005 03:08PM
Re: Why this is slow ?
1369
Roland Bouman
December 01, 2005 04:16PM
Re: Why this is slow ?
1712
hello world
December 02, 2005 03:38AM
Re: Why this is slow ?
1672
Per-Erik Martin
December 02, 2005 05:13AM
Re: Why this is slow ?
1628
hello world
December 02, 2005 12:26PM
Re: Why this is slow ?
1705
Ralf Keller
December 02, 2005 09:42AM
Re: Why this is slow ?
1648
Ilia Ratchinski
December 02, 2005 02:18PM
Re: Stored procedure applied but still extrem slow.
1666
hello world
December 03, 2005 10:03AM
Re: Stored procedure applied but still extrem slow.
1522
hello world
December 03, 2005 10:08AM
Re: Stored procedure applied but still extrem slow.
1659
Roland Bouman
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.