MySQL Forums
Forum List  »  Newbie

takeing 17 minute 30 second ???
Posted by: helo worl
Date: February 10, 2005 02:31PM

Question: How to solve the query time ? its takeing 17 minute 30 second ???

Description:

CALLS ROW = 9000
RATE ROW = 27 000

MySql Syntax:
select Zone,Code, (select rate_id from rate where rate_id=zone and c_code=code) from CALLS;

Query Time: 17 minute 30 second

Options: ReplyQuote


Subject
Written By
Posted
takeing 17 minute 30 second ???
February 10, 2005 02:31PM
dig
February 10, 2005 03:32PM


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.