Hi -
When we connect to the Progress OpenEdge DB with the 10.2 A driver, and execute a SQL statement having a simple inner join conditions ( the where clause are all indexed columns), it takes more that 4 - 5 minutes for the first time. However if we run the query next time, they return the result in seconds. The slowness in the query is again observed if the database is not used for couple of hours, and after the first execution the record retrieval is fast again.
The DB size is 9 GB and the update statistic have been run on the database.
Thanks for your help.
OE
When we connect to the Progress OpenEdge DB with the 10.2 A driver, and execute a SQL statement having a simple inner join conditions ( the where clause are all indexed columns), it takes more that 4 - 5 minutes for the first time. However if we run the query next time, they return the result in seconds. The slowness in the query is again observed if the database is not used for couple of hours, and after the first execution the record retrieval is fast again.
The DB size is 9 GB and the update statistic have been run on the database.
Thanks for your help.
OE