ODBC Performance problem

LuckyLuke · Post by **LuckyLuke** » Mon 27 Sep 2010 13:41

How can I increase the speed of a query ? It takes about 20 seconds before returning 2000 records using Delphi + UniDAC.
Database : SQL Anywhere 11
Query : Select * from customer

Using Powerbuilder + ODBC :
2 seconds to get all the records.

I would like to convince my manager to use Delphi and UniDAC. This performance problem is the only problem left.

Thanks.

AlexP · Post by **AlexP** » Tue 28 Sep 2010 09:14

Hello,

I tested your example on latest UniDAC version (3.50.0.12), and time to open the query was less than 2 sec on 30000 records.
Please tell me your exact version of UniDAC.
Also if you don't use default TUniQuery settings, please specify your settings, or send a small project to demonstrate the problem to alexp*devart*com.