Hey all,
First of all. I have this issue in all APEX versions (ok I haven't tried it in 4.2 yet cause I have no built to deploy) but.
In our DTAP (Dev/Test/Acceptance/production) we use maven and liquibase to make packages of code and deploy them to the next environment.
Afterwards we export the application and import it again in the next environment.
Exporting the application is fine, but importing takes a very very long time. Now I've tried this also with sqlplus scripts and that seems to go pretty fast.
begin
apex_application_install.set_workspace_id(#workspace_id#);
apex_application_install.set_application_id( #new_application_id# );
apex_application_install.set_schema(#schema#);
apex_application_install.set_offset(#random_number#);
end;
/
begin
wwv_flow_api.set_security_group_id(#workspace_id#);
end;
/
@"src/main/APEX export/f20100.sql"; -- Application export
@"src/main/APEX export/f20100_so.sql"; -- Export of the supporting objects
/
This code works very fast, but on some environments at our customers we do not have permission to do this.
I'm just wondering, why does that "Install Database Application" page works so damn slow.
Why does it take with an application of around 2MB like 2 minutes just to change the application id ??? Aren't these just the same processes as called in my procedure???
After all the application is already imported by then and installation of the application + supporting objects goes pretty normal by mine account
Does it really have to check the entire application each time that page is submited. Couldn't we turn that off somehow??
This is really minor in APEX. At some of our customers we needed to increase the time-out off the application server to import an application else we got a connection time out. Application size was around 10MB...
So in short is there a way to make the "Install Database Application" page faster, or a best practice for importing applications with a DTAP environment.
Any help is greatly appreciated.
Regards
Nico