Dear Formspider Team, I have one SQL on datasource. And when Forspider app executes it app is frozing and dont get the results. I execute same query on DB and get results quickly. Why this happening ? How to solve the problem ? SQL is with dblinks. Please assist asap. |
I dont think query can help because i execute same query on DB and its working.. I execute it as usual through grid. And select stays on sessions browser and waits data from dblink.. How can be the problem solved? I can send you select but its a little big.. and connects to different DB through link.. you wont be able to test it.. SELECT * FROM PMS_CALL_DETAIL@TO_XDR CD LEFT JOIN PMS_CALL_PARTITION@TO_XDR CP ON ( CD.CALL_SERIAL = CP.CALL_SERIAL AND CD.MSISDN = CP.MSISDN AND CP.EVENT_TIME = CD.EVENT_TIME) WHERE CD.EVENT_TIME BETWEEN TO_DATE (:B3, 'DD.MM.YYYY HH24:MI:SS') AND TO_DATE (:B2, 'DD.MM.YYYY HH24:MI:SS') AND CD.MSISDN = REVERSE (:B1) ORDER BY 1
(28 Jun '13, 07:11)
Khayyam
this query stays on session browser and waits data from dblink.. on DB it works very quickly.
(28 Jun '13, 07:12)
Khayyam
Any ideas ?
(30 Jun '13, 23:58)
Khayyam
Hi Khayyam, These days are rather busy. We'll take a look at this issue soon.
(02 Jul '13, 01:04)
Yalim ♦♦
|
Hi Khayyam, may be we can help you if you provide more information. Please write your query here or send to contact at theformspider.com, so we can take a look. Also you can share info about your application and how you execute that query.