by I have noticed a memory Loss in this case:
Suppose you have a parser that takes the following file:
INSERT INTO PIPPO (A,B,C,D) VALUES (1,2,3,4);
UPDATE PIPPO.....
INSERT INTO PIPPO (A,B,C,D) VALUES (4,5,6,7);
....
....
Then you have the following istructions in your program......
Public Function ExecuteSQL( _
sql As String, _
Optional outError As Variant _
) As Boolean
Dim localComm As New ADODB.Command
Set localComm.ActiveConnection = mDB
localComm.Prepared = False
localComm.CommandText = sql
localComm.Execute
ExecuteSQL = True
Set localComm = Nothing
End Function
I have noticed that the MEMORY increases for the process DURING EXECUTION
(SLOWLY BUT INCREASE). It seems that there is a CACHING of THE ISTRUCTIONS
....
But if THE SQL ISTRUCTIONS TO BE PARSERIZED ARE
SELECT * FROM PIPPO WHERE 1= 1
SELECT * FROM PIPPO WHERE 1= 1 (IDENTICAL FIRST SQL INSTRUCTION)
SELECT * FROM PIPPO WHERE 1= 1 (IDENTICAL FIRST SQL INSTRUCTION)
SELECT * FROM PIPPO WHERE 1= 1 (IDENTICAL FIRST SQL INSTRUCTION)
The memory doesn't INCREASE when program is executed
How can I can SAY to ADO TO DON'T USE CACHING FOR INSTRUCTIONS ?
Thanks