Problem in Speed

[yar]

I use Component TQuery, works in Sybase Anywher 11.

I want to use your component TUniQuery.
Problem in Speed.
I run SQL: 'Select * from Cards ;
Then I run Query.Last
In Table Cards 30000 records and 200 fields

Component TQuery run in 0.7 seconds,
component TUniQuery - in 4.4 seconds (4.3 seconds in Query.Last)

What is problem ?

I set properties of TUniQuery:

Options.FlatBuffers = TRUE
SpecificOptions.Values['FetchAll'] = 'False'

[AlexP]

Hello,

Try to estimate the overall time in both components - DataSet opening and switch to the last record – and inform us the result

Code: Select all

var
  c: cardinal;
begin
  c := GetTickCount;
  UniQuery1.Open;
  UniQuery1.Last;
  ShowMessage(IntToStr(GetTickCount - c));
end;

[yar]

This is exactly what I did and I got the slow:
Component TQuery run in 0.7 seconds,
component TUniQuery - in 4.4 seconds (4.3 seconds in Query.Last)

I want to know how you can improve the speed at least be similar to BDE?

[AlexP]

Please provide the script for creating the table and your SQL query text.

[yar]

Hi,

1. Attached hereto is an example of the problem in Delphi 7
2. Script to create the table (DBA.Cards.zip)

Download Link
https://dl.dropboxusercontent.com/u/107 ... edTest.zip

[AlexP]

We have already increased performance for the ODBC provider. Now, UniDAC surpasses even BDE in performance. This feature will be included in the next UniDAC version.

[yar]

When the new version is supposed to come out?
And what will be the version number?

[AlexP]

We are waiting for the Rad Studio XE7 release. As soon as the IDE is officially released, we will release the new versions of our products.