Long Startup and Access Time in Application

[John Antoniewicz]

What is the best way to define a TOracleDataSet at development and at program startup to allow the application to start while the tables are being open? I have defined indexes for these tables but I noticed it takes up to 2 minutes before my application screen appears. There are only three tables; the smallest containing only 40000 rows and the largest containing only 180000 rows. These tables are linked to each other using Master Table/Master Fields or variables in the SQL.

I have tried working with the settings. I even set QueryAllRecords to False.

 

[Marco Kalter]

You should use the Oracle Monitor to find out what causes these 2 minute delays. Then you will know where to look for an optimization.

------------------
Marco Kalter
Allround Automations