Out of memory on TMSQuery

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Mon 02 Apr 2007 14:57

Out of memory on TMSQuery

Post by PRioux » Mon 02 Apr 2007 15:52


I have one situation where I get an out of memory when executing a huge query. Is there a setup parameter somewhere to override?
The same query is running corretly in query analyzer tools.

SQL server 2000
SQL Server Data Access Components Professional version (29.09.06)

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Tue 03 Apr 2007 12:14

Please specify the query you use and definition of necessary database objects.

Posts: 55
Joined: Wed 04 Apr 2007 17:25

Post by tonisanta » Wed 04 Apr 2007 17:34

try to limit the fetchcount and set fetchall to false; could be query analyzer does not take in memory all records o uses less overhead the the vcl-datasets

Post Reply