Slow on Android

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ads42
Posts: 36
Joined: Tue 08 Jan 2013 14:13

Slow on Android

Post by ads42 » Wed 01 Oct 2014 13:01

Hi,
I'm testing XE7 and MyDac.
For retrieving 9000 records (using a TMyQuery on Windows it takes less than 2 seconds.
On my new Galaxy Tab Pro (quad core) it takes about 16 seconds :shock:
Is there something specific I can do to improve speed ?
Regards

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Slow on Android

Post by ViktorV » Thu 02 Oct 2014 10:08

A lot of factors affect the difference in performance between desktop and mobile applications: network organization (LAN/WAN), CPU architecture, etc.. Therefore longer fetch time on Android in comparison to Windows applications is quite natural.
The TMyQuery component has the FetchAll and FetchRows properties, which default values are True and 25, correspondingly. If FetchAll = False, only FetchRows of rows will be read during the fetch of the TMyQuery.Open method.
The rest of the rows will be fetched by necessity.
You can read about it in the MyDAC help: http://www.devart.com/mydac/docs/devart ... tchall.htm

ads42
Posts: 36
Joined: Tue 08 Jan 2013 14:13

Re: Slow on Android

Post by ads42 » Thu 09 Oct 2014 14:08

Thanks for your reply I have set it to false and still very slow I see no difference.
I use a TListView and a TBindSourceDB, could it be the reason ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Slow on Android

Post by ViktorV » Fri 10 Oct 2014 13:35

Our products performance doesn't depend on the components you specified. Please refer to the Embarcadero documentation to learn how to use these components correctly.

Post Reply