LiteLoader very slow using encrypted DB

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ecl
Posts: 4
Joined: Tue 18 Sep 2012 13:13

LiteLoader very slow using encrypted DB

Post by ecl » Wed 19 Sep 2012 11:54

Hello.

When using LiteLoader with an encrypted database data loading is very slow.

I changed the encryption algorithm and "page_size" and the results are the same.

Using the database without encryption speed is very good.

I'm using Delphi 7 and LiteDAC 1.5 trial.

Thank you.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: LiteLoader very slow using encrypted DB

Post by AlexP » Fri 21 Sep 2012 10:29

hello,

We checked the LiteLoader performance on an encrypted DB, and the performance crash on an encrypted DB is not heigher than 15%, this is due to the fact that the process of encryption/decryption takes some time.
We have performed re-factoring of the data loading process using TLiteLoader, and the data loading speed will be increased significantly.

ecl
Posts: 4
Joined: Tue 18 Sep 2012 13:13

Re: LiteLoader very slow using encrypted DB

Post by ecl » Fri 21 Sep 2012 11:38

Thank you.

Could you give me any estimation on when the next LiteDAC build might be released?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: LiteLoader very slow using encrypted DB

Post by AlexP » Fri 21 Sep 2012 12:18

hello,

The release of the new LiteDAC version is planned for a month, however, we can send you a trial betta-version of LiteDAC with this functionality. Please specify your e-mail, where we can send a betta-version.

Post Reply