Extreme loading time when opening a page the first time

It is expected and acceptable that this will take a little longer then normal. However the company I am working now has extreme long loading times. At first I thought this to be caused by the complexity of the software however for a test we created some simple pages that had hardly any content and these were also extremely slow.

So, to be sure, I created a complete empty module just to see how the system would deal with an empty espace. This emptyModule had a initial loading time of 1 min and 10 secs!

I have never seen a initial loading time with a OS system this slow. The problem is not caused by AV or disk space problems.

The used database here is an Oracle (they have also a NULL problem laying around ;) ).The test page itself is empty, also the used application is empty: no entities except the system tabel, no logic, no dependencies, etc. Just 1 screen that takes >1 minute to (initial) load.

They have had this problem for a long time now, they tried several things with connection- and application pools but I will relay your remarks just to check everything.

With using a profiler on the server we saw that there was some strange behavior around connecting to the LDAP server. After consulting with our Oracle DBA we understood that we used LDAP first and tnsnames as backup and therefor discovered that the data in the OS config tool was "incorrect": under the database and session tabs the used naming method was set to service name.

The data itself was correct however due to the way Oracle was set up it was not the correct choice. The naming method should be Tnsname. In this way Oracle will see that they should be using LDAP before Tnsnames. Very logical :) Luckily our DBA saw that the previous settings made no sense regarding the Oracle setup.

So, inital load went from 1,5 min to 1.2 sec!! We're happy now and will go on to do some more test how this will affect our total system in a positive way :)