Memory leak

stephane · Post by **stephane** » Fri 12 Sep 2008 10:05

I am testing DBX drivers for interbase and Firebird because the standard DBX4 drivers cause memory leak when i use the following instructions in a loop (very simple program) :
sqlconnection.open;
sqlconnection.close;

With upscene drivers there is no leak (or very little memory leak).
With devart drivers (trial version), the leak is very big.

I would like to use Devart drivers because i use both Interbase and firebird but the memory leak block my decision.

Best regards

Plash · Post by **Plash** » Mon 15 Sep 2008 08:57

This memory leak is caused by reloading the driver DLL each time you reconnect. You can avoid the leak and increase connection performance by preloading the driver DLL:

Code: Select all

var
  LibHandle: THandle;

initialization
  LibHandle := LoadLibrary('dbexpida40.dll');

finalization
  FreeLibrary(LibHandle);