I am trying to build a system that will handle concurrent DB requests efficiently, there's not a lot of load, but it should be able to handle more than 1 query concurrently.
I am using FireBird v3.0.4 and Delphi 10.3.2 with the TFDConnection component.
I am hosting the code in an ISAPI DLL that runs on IIS 7.5.
Right now I'm creating the DB connection using TFDConnection in the DLL's "initialization" section.
However, I noticed that even under low-load (2-3 users), I occasionally get an "[FireDAC][Phys][FB]Error reading data from the connection." exception when performing a DB query (not the same DB query, it seems pretty random).
I tried to research the error and didn't find anything clear, the best I got was :
https://forums.embarcadero.com/thread.jspa?threadID=245750
Which seems to indicate that I should instance a copy of TFDConnection for every query.
Before I make significant code changes to test this, I would welcome any tips on the best approach to handling DB concurrency.