I also supposed so, but I create the datamodule dinamically at runtime when I need to connect, so the global connection time would be the same (when the program start, the TOracleSession component does not exist). If I execute the steps:
1) At design time I set the right server,username,password and connected at true,
but the datamodule is not autocreated when the program starts.
2) When I need to connect I create the datamodule in which I put the TOracleSession component. Because of the setting of the properties (see 1), the creation and connection happen at the same time.
3) I Execute the query.
Doing so, the creation of the TDatamodule with a connected session is very fast. I do the job in few milliseconds.
Instead, if I execute
1) At design time I don't set right server, username and password and I set connected at false.
2) When I need to connect I create the datamodule. Then, I set right server etc. and connected at true.
3) I execute the query.
Doing so, the setting of connected at true needs 2-3 seconds. I need this time to do the job! The strange thing is: I have also the same version of Oracle on Linux and with it the problem does not exist, it happens only when I connect to Oracle on Sun Solaris.
What can I do? :-)