Test Advanced Query is sloooow!

Test Advanced Query is sloooow!

  
Why does "Test Query" take so long? On my computer it can take up to minutes long to test an advanced query.
Hi Ashirvaad,

Usually test query is relatively fast.
What version of Service Studio and Platform Server are you using?
Is the query itself in runtime taking too long?

Regards,
João Rosado
Hello João
Thanks for responding :-)

I'm using Platform Server version 5.1.1.24 and
Service Studio version 5.1.1.24, with Oracle 11g2 in Windows 2003 R2 x64. Neither machine (Platform Server / Database Server) is a "slow" computer. The network between them is not slow.

The queries execute very quickly (<500ms) at runtime. At design time, it takes many seconds, sometimes up to 2-3 minutes to test a query from Service Studio. Is this normal? Is my local computer (Dual-Core 2.0GHz, 32bit Win Vista, 3GB RAM) where I run Service Studio the bottleneck?

Is there a recommended spec (CPU, disk, RAM, OS) for the Service Studios to run well? We have a big eSpace that is ~8MB in the OML form. Is that the world's biggest eSpace? Is the norm for applications to be much smaller than that? How much smaller? What are the limits?

I know it's a lot of questions, sorry, hoping to get a feel for what to expect as "normal" conditions.

Ashirvaad