After doing a fresh instal of Servoy 3.5 final in an Oracle 10gr2 database
i startup developer and open no solution.
The first time i choose “edit preferences” it is very slow, it takes 30 seconds or more before the preference tab is displayed.
During this time the Oracle database is taking all available cpu.
This was different in Rc6 and before.
This happens every first time after startup of developer.
If you select “edit preferences” a second time it is fast as it used to be.
If i do the same in an Servoy installation that has been installed from 3.5b2 and the upgraded up to 3.5 final and has several solutions in it, i have to abort Servoy, because the preferences are never shown ( i waited for 1o minutes)
Could a Servoyan respond to this issue ?
I will also log a case in the support system
I too have found this to be the case with my Oracle 10g solutions. I don’t know when it started but the preferences are very slow to load with any solution that points to Oracle. I also find it very, very slow loading dataproviders when Oracle is involved.
I did some performance analysis and discovered a few “heavy” queries.
I looks like Servoy does several queries to get all table, view, column information from all the schema’s in the database.
They seem to be inefficient.
Don’t know why this is necessary when you choose “edit preferences”
Are you limiting the servoy connection to a particular schema? That’s what I do with Oracle. Then if I need a different schema within a Servoy solution I make a separate Servoy connection to it. Or are you saying Servoy gets all schemas within a database regardless of whether you have limited a connection to a particular schema?
The thing that I find when pulling up the dataproviders is that it seems that the queries themselves that are pulling up the information on tables, views and schemas take a long time. I say that in comparison to another Java/JDBC tool which must call up the exact same system table data. With Aqua Data Studio I have the same ‘connections’ to Oracle that I have with Servoy. But there when I go look at the column/table/schema details it is much faster, essentially immediately. I’m presuming that has to do with the query.
I do it the same way.
I make a separate Servoy connection for each schema.