Postgres: Performance-Issues after updating from UniDAC 9.4.0 to 10.2.1
Hello,
we massive perfomance issues after updating to your newest version.
For example:
TUniTable (default settings), TUniConnection (already connected), Table with 621 Records
- Version 9.4.0: Open returns after ~25ms
- Version 10.2.1: Open returns after ~220ms
I think that one problem is the multple call from GetExtFieldsInfo. Two calls for one open.
TUniQuery.Prepare
The explicit call 10 to 20 seconds on slow machines for an simple statement like SELECT * FROM table WHERE ID = :ID
Any Suggestion? We are about to deliver a new customer version and are unable to deliver in this state.
Best regards,
Manuel Bursch