Hi, I am having a problem with the following query. It seems to force php to timeout after 30secs. The query goes through 150K records. Is there anything I can do to speed it up?
code----------------------------------------- SELECT call_id, C.extn_no AS extn_no, dest, dest_name, call_time, duration, cost, U.firstname AS firstname, U.surname AS surname FROM call_data as C LEFT JOIN users as U on C.extn_no = U.extn_no WHERE C.stamptime >= $unixtimestart AND C.stamptime <= $unixtimeend AND direction = 'Out' ORDER BY cost desc LIMIT 0,16 -------------------------------------------------------------- Lloydie-t
