![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Fri, Jan 15 2010 3:42 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Environment
ElevateDB 2.03b6 (soon b7 ![]() 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 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I think I've tracked it down. Nothing to do with MadExcept - its FastMM in debug mode that's the problem.
Roy Lambert |
This web page was last updated on Thursday, July 10, 2025 at 01:54 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |