Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread ElevateDB and MadExcept
Fri, Jan 15 2010 3:42 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Environment

ElevateDB 2.03b6 (soon b7 Smiley
Vista SP2
Delphi D2006
MadExcept 3.0f

I'm experiencing some problems with MadExcept. In one case a query runs 7x slower with MadExcept as part of the app than without it and in another MadExcept (but only in the IDE) seems to "hold onto" memory.

The query is

SELECT _ID, _fkSites, _fkCompanies, _fkContacts
FROM Career
WHERE
(_fkContacts = :ContactID OR :IgnoreContact)
AND
(_fkCompanies = :CompanyID OR :IgnoreCompany)
AND
_Left IS NULL

The retained memory is caused by importing from csv files in a loop

....
       Qry.SQL.Text := 'DELETE FROM "' + Tables.Items[Cntr] + '"';
       Qry.ExecSQL;
....
       Qry.SQL.Text := 'IMPORT TABLE "' + Tables.Items[Cntr] + '" FROM "' + Tables.Items[Cntr] + ExportFileExtn + '" IN STORE "' + StoreName + '"';
       Qry.ExecSQL;

Is anyone else seeing these sorts of issues?

Roy Lambert
Fri, Jan 15 2010 9:28 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I think I've tracked it down. Nothing to do with MadExcept - its FastMM in debug mode that's the problem.

Roy Lambert
Image