[sqlite] Why does my query take so long

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,

[sqlite] Why does my query take so long

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,

Re: [sqlite] Why does my query take so long

Hi, 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,

Re: [sqlite] Why does my query take so long

Ulrik Petersen wrote: Hi, 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,