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
PRioux
Posts: 1
Joined: Mon 02 Apr 2007 14:57

Out of memory on TMSQuery

Post by PRioux » Mon 02 Apr 2007 15:52

Hi,

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 3.80.0.32 (29.09.06)
Top
Jackson
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.
Top
tonisanta
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
Top
Post Reply

Return to “SQL Server Data Access Components”