importing slow

Classic Servoy
1

Hi,

I am running servoy 5.2.8 on an Oracle 11gr2 database for a while now on my laptop.
Production is still on 10gr2.

On my laptop everything runs fine when using developer.
Today for the first time I started Servoy server on my laptop and tried to import some solutions.
This takes very,very long and I notice that the Oracle Vm is using 100% of it’s cpu for oracle.

Is this a known issue or ??

Regards,

2

I did some more testing on 2 configurations

  1. windows 7 64 bit Servoy server 5.2.8
    java 1.6.0_24
    database Oracle 11gr2 64 bit on Oracle Linux 5 Vmware
    Oracle Ojdbc6 jdbc driver

  2. windows 7 32 bit Servoy server 5.2.8
    java 1.6.0_26
    database Oracle 11gr2 on windows 32 bit (same server as Servoy)
    Oracle Ojdbc6 jdbc driver

When importing a somewhat bigger solution (3 Mb ) you can see the problem in the taskmanager in windows (in both configurations).
When the import starts You see two processes using cpu power ( Java and Oracle ).
After 1 or 2 minutes, the Java proces does nothing any more and Oracle takes full power of 1 cpu.
This still runs after 30 minutes, then I stopped it.

When I use the Ojdbc14 driver it works fine in configuration 2 The import takes about 3 minutes.
Configuration 1 does still not import.
Does Servoy have an advice which Oracle Jdbc driver to use with Oracle 11gr2 and Servoy 5.x ??

I think Oracle reccomends Ojdbc6.

Can one of the Servoyans answer this one ??

Regards,

3

Additional info :

With Servoy 6 there is no problem importing !!

In all configurations the import works.

Does this mean that Oracle 11gR2 is supported only with Servoy 6 ???

Regards,