SQLDBRestBridge - Ever increasing memory consumption.
lazarus / 38-Networking and Web Programming

----------------------------------------------------------------------
Elfrom · 2020-10-26 20:37

Hi, community
I think the SQLDBRestbridge is probably one of the coolest new
features in FPC and Lazarus (2.1), at least it is new to me 
It is so simple to use, yet so powerful.

Well every rose has its thorns, so here goes:
I have a present need to access (read/write) a database over the
internet and thought I would solve the job with this new wonderful
tool.
I use the demos as a kind of proof-of-concept, the only thing I
changed is that the database i use is a MSSQL database.

I experienced two problems:
  * Every time  I connect to the REST-application it creates a new SQL
connection, but it never disconnects. Solved by: "aConn.Close(True)";
in "DoAfterRequest"
  * Memory is allocated and never released, i am guessing it has to do
with the SQL-connections mentioned above but I can not find out when
or where I can free the connections.

My problem(s) can be recreated with the demos for both Lazarus and
fpc.
lazarus\components\sqldbrest\demo\restbridge
fpcsrc\packages\fcl-web\examples\restbridge

Versions:
  Lazarus 2.1.0 date 2020-10-20
  FPC 3.2.1
  SVN Revision 64044

Platform:
  Windows 10 x64

/Elfrom