DAC Team posts

Useful components, FTP and FTPS protocols support, and much more in the upgraded SecureBridge!

Devart is proud to announce that it has released the new version of SecureBridge, a network security solution. SecureBridge now provides a possibility to connect to a remote host through a proxy server, thus making indirect network connections to various network services. (more…)

Devart presented EntityDAC at this year’s Coderage XII conference

Devart was pleased to participate in the annual online conference for Delphi developers – Coderage XII organized by the Embarcadero company and held on November 7-9, 2017. (more…)

Fast and simple database app development and deployment to Linux in RAD Studio

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode (more…)

How to retrieve data from Dynamics CRM to MS Access using ODBC

Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. (more…)

Developing applications with Salesforce CRM integration in Delphi

Cloud-based CRM systems are becoming incredibly popular in these days. This trend is quite clear. The usage of cloud services does not require a deployment and costly specialized software domestic support, which ultimately reduces a company’s total expenses. (more…)

How to import data to Excel using ODBC

In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving process.
Cloud technologies develop rapidly, more and more data is stored in the cloud. (more…)

Use VirtualDataSet to access objects list via TDataSet interface

TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms. TVirtualDataSet behaves the same way as any other TDataSet (more…)

Installation & Configuration of Devart ODBC Driver for QuickBooks

The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks account, and provides a demo sample of retrieving QuickBooks account data using Microsoft SQL Server Management Studio.

(more…)

How to combine data from several sources using SQL and VirtualQuery

The VirtualQuery component allows to perform SQL queries to sources, that are not a database, but a TDataSet or any its descendant. It also allows to connect to several data sources at a time and work with them using SQL queries as with a single data source. (more…)

Increasing SQLite Performance

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue.

Perhaps, a classic case everyone gets into when using SQLite for the first time is very slow execution of multiple INSERT/UPDATE/DELETE operations. Indeed, sequential executions of not even thousands, but hundreds of INSERTs into a table may take too long.
The origin of the issue lies in the specificity of using transactions in SQLite. SQLite starts a transaction automatically every time before any DML statement execution and commits it after execution. Accordingly, when executing multiple consequent statements, a new transaction will be started and committed for each statement.

The solution of this problem is quite simple — the block of DML statements may be enclosed into BEGIN … END operators block ( http://www.sqlite.org/lang_transaction.html ). In this case, each DML statement won’t be executed in a separate transaction, but a single transaction will be started before the whole block execution and committed after all modifications.

Such an approach increases SQLite data modification performance by times. See more details about it in the SQLite documentation ( http://www.sqlite.org/faq.html#q19 ).

However, this approach is not the only way to increase performance in SQLite. Parameters of the DBMS may also be configured using so-called PRAGMA ( http://www.sqlite.org/pragma.html ). The fact is that SQLite parameters are oriented not to high performance by default, but to maximum data safety and integrity. Modification of these parameters may increase performance, however, note, that the data corruption risks increase too.

Let’s analyze the impact to inserts performance by different PRAGMAs using LiteDAC. (more…)