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.

asked 28 Jun '13, 06:52

Khayyam's gravatar image

Khayyam
134
accept rate: 0%

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.

(28 Jun '13, 07:03) oskansavli ♦♦

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..

link

answered 28 Jun '13, 07:08

Khayyam's gravatar image

Khayyam
134
accept rate: 0%

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 ♦♦

Dear Yalim,

The problem is not actual. I have solved it.

Thanks.

link

answered 02 Jul '13, 03:31

Khayyam's gravatar image

Khayyam
134
accept rate: 0%

Cool. Happy to hear this!

(02 Jul '13, 03:33) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1

Asked: 28 Jun '13, 06:52

Seen: 842 times

Last updated: 03 Jul '13, 04:52

Related questions


© Copyright Gerger 2017