Hi,

Any online to help me in fetching the data's quickly. if i run the query below its taking such a long time due to huge data's(1k) in each tables. Can any one help me in this..............

Thanks,

Shobana

DROP TABLE IF EXISTS OwnerMessageList1;

DROP TABLE IF EXISTS OwnerMessageList2;

CREATE TEMPORARY TABLE OwnerMessageList1 (

id serial,

name varchar(100)

);

CREATE TEMPORARY TABLE OwnerMessageList2 (

id serial,

srcname varchar(100),

url varchar(1000),

username varchar(200)

);

INSERT INTO OwnerMessageList1

(name)

select unnest(string_to_array(replace(replace('$filter', 'itime >= ', ''),'itime <= ',''),'and'));

INSERT INTO OwnerMessageList2

(srcname,url,username)

select distinct am.src,am.url,am.user from "FGT60B3908669009-wlog-1380091698" am where cast(am.itime as integer) between (select cast(name as integer) from OwnerMessageList1 where id=1) and (select cast(name as integer) from OwnerMessageList1 where id=2) ;

select am.srcname,am.url,am.username,abstime(cp.itime) as itime ,abstime(cp.dtime) as dtime from "SYSLOG-C0A80A41-glog-1380349435" cp join OwnerMessageList2 am on cp.msg LIKE '%'||am.srcname||'%' where cast(cp.itime as integer) between (select cast(name as integer) from OwnerMessageList1 where id=1) and (select cast(name as integer) from OwnerMessageList1 where id=2) order by cp.itime desc