Fastest data access

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Tarifer
Posts: 21
Joined: Thu 26 May 2011 08:13

Fastest data access

Post by Tarifer » Tue 28 Aug 2012 08:08

Hello!

What is fastest way to read data?
I open simple SQL and read big amount of data (50M rows for now).
I can't use group (I backup every row to).
Can I use some fast low-level interface for data access?

Thanks,
Dmitry Ukolov.

ZEuS
Devart Team
Posts: 236
Joined: Thu 05 Apr 2012 07:32

Re: Fastest data access

Post by ZEuS » Wed 29 Aug 2012 11:16

SQLite does not provide any special API functions for fast reading large amounts of data.
LiteDAC is built using fast and optimized data access algorithms, so using LiteDAC you get a quite high performance level.
In order to increase data reading speed, you can set the LiteQuery.UniDirectional property to True and the LiteQuery.FetchAll property to False.
Please note that UniDirectional datasets cannot be modified.
For more information about increasing performance, please refer to the "Increasing Performance" article in the LiteDAC documentation.

Post Reply