Delphi Cookbook - Third Edition

Getting ready

We've to generate one text file for each customer in the database containing a list of its sales. The filename should contain the customer code, which is something like customer_00123.txt. Consider that, in many cases, the connection and login phases are the slower operations when dealing with a short connection to the database. So, we have to handle this problem too. Luckily, FireDAC provides pooled connections, and they are a must when using concurrent database accesses in multithread scenarios. Let's start by checking the recipe's code.