Page 1 of 1
Problem in Speed
Posted: Sun 17 Aug 2014 10:19
by 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'
Re: Problem in Speed
Posted: Mon 18 Aug 2014 11:59
by 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;
Re: Problem in Speed
Posted: Mon 18 Aug 2014 15:00
by 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?
Re: Problem in Speed
Posted: Thu 21 Aug 2014 10:40
by AlexP
Please provide the script for creating the table and your SQL query text.
Re: Problem in Speed
Posted: Mon 25 Aug 2014 07:08
by 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
Re: Problem in Speed
Posted: Tue 26 Aug 2014 09:55
by 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.
Re: Problem in Speed
Posted: Tue 26 Aug 2014 16:04
by yar
When the new version is supposed to come out?
And what will be the version number?
Re: Problem in Speed
Posted: Wed 27 Aug 2014 07:07
by 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.