I'm coming here because I've exhausted my knowledge and search skills.
I have a very simple application with Delphi XE2 and Firedac (Version 8.0.3) which uses TADQuery to insert a registry in a table that contains 800k rows (10 columns), primary key is bigInteger incremental.
The first insert runs very slow and the subsequent inserts are almost instantaneous until i restart the application, after restarting the application the first Insert runs very slow again.
I tried to run the same statement in IBExpert, all statements are instantaneous.
So, must be something in the component right ?
I'm using TADConnection + TADQuery to run all statements.
Some properties maybe in the TADConnection or TADQuery maybe ?
Any help will be welcome