ADO 2.5 Sql Server Ole Db Provider and Memory Loss 
Author Message
 ADO 2.5 Sql Server Ole Db Provider and Memory Loss

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



Thu, 25 Nov 2004 04:56:08 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. OLE DB Provider for SQL Server Message and COM Message

2. Timeout expired, [Microsoft OLE DB Provider for SQL Server]

3. About nested transation of OLE DB provider of Sql server

4. Error: 2147467259 was generated by MS OLE DB provider for SQL Server DBNETYLIB ConnectionWrite(send())

5. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

6. ODBC provider vs MS SQL provider (OLE DB)

7. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

8. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

9. New features in ADO 2.5 / Jet OLE DB 4.0

10. Using ADO 2.5 Streams on SQL Server 7.0

11. ADO 2.5 / Win2K / VB IDE / SQL Server 7.0

12. ADO - OLE DB - ODBC - SQL Server

 

 
Powered by phpBB® Forum Software