Click here to Skip to main content
15,883,127 members
Home / Discussions / Database
   

Database

 
GeneralProcess SQL Transactions?? Easy Question :) Pin
mittalpa27-Oct-03 6:41
mittalpa27-Oct-03 6:41 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
Mike Dimmick28-Oct-03 2:13
Mike Dimmick28-Oct-03 2:13 
GeneralRe: Process SQL Transactions?? Easy Question :) Pin
mittalpa28-Oct-03 3:17
mittalpa28-Oct-03 3:17 
GeneralMemory Leak! Pin
Kevin Gutteridge27-Oct-03 0:36
Kevin Gutteridge27-Oct-03 0:36 
GeneralRe: Memory Leak! Pin
Mike Dimmick28-Oct-03 3:00
Mike Dimmick28-Oct-03 3:00 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:03
Kevin Gutteridge28-Oct-03 22:03 
GeneralRe: Memory Leak! Pin
Mike Osbahr28-Oct-03 3:38
Mike Osbahr28-Oct-03 3:38 
GeneralRe: Memory Leak! Pin
Kevin Gutteridge28-Oct-03 22:47
Kevin Gutteridge28-Oct-03 22:47 
Hi Mike,

I've spent hours looking at this and can get lots of differnet results.
The best solution (although no pratical for performance reasons) is to move the connection and Recordset inside the loop, this seems to leak less!

My understanding of MDAC is that it buffers memory allocations and the default setting is 500 queries * 1Mb. This is why running the test program the memory allocated seemed to drop rapidly to begin with then level off (the problem is I never seem to get it all back!). With the connection and Recordset inside the loop a much smaller leak is seen. The trick is the changing WHERE clause, if this is static then no problem (presumably because no malloc/free's are occuring)

According to a Microsoft artical you can adjust the 500 cached queries settings and the amount of memory allocated, I've tried setting these but cannot get any different results.

I let you know if I discover anything further.

Regards,
Kevin.
GeneralHi All Pin
Venkatraman26-Oct-03 13:55
Venkatraman26-Oct-03 13:55 
GeneralSQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 12:58
moredip26-Oct-03 12:58 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 13:14
Edbert P26-Oct-03 13:14 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip26-Oct-03 13:22
moredip26-Oct-03 13:22 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Edbert P26-Oct-03 15:15
Edbert P26-Oct-03 15:15 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 
AnswerRe: Why the connection is so slow? Pin
Paul Watson25-Oct-03 4:31
sitebuilderPaul Watson25-Oct-03 4:31 
AnswerRe: Why the connection is so slow? Pin
Rob Graham25-Oct-03 5:36
Rob Graham25-Oct-03 5:36 
AnswerRe: Why the connection is so slow? Pin
Mike Dimmick28-Oct-03 3:12
Mike Dimmick28-Oct-03 3:12 
GeneralQuery Pin
Anonymous24-Oct-03 3:08
Anonymous24-Oct-03 3:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.