Re: ADO faster than ADO.net ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Cor,

Would you mind sending me back your changes so I can see what you did. Feel
free to email me at bw@xxxxxxxxxxx

Thanks for your input and advice.

Brian



"Cor Ligthert" wrote:

> Brian,
>
> Interesting. I tested it.
>
> Your code with the parameters was not ideal.
> Making that better I got the same result as with the insert SQLString
>
> I also added a procedure with a stored procedure and could win 20%.
>
> However it was still 4 a 5 times slower than ADODB.
>
> I know that it does not help, however maybe was you interested if others
> would try that nice test from you.
>
> By the way, all that setting to nothing is for nothing, it goes all out of
> scope.
>
> I hope this helps something,
>
> Cor
>
>
>
.

Relevant Pages

  • Re: Looping through a Datagrid
    ... line basis? ... > What you can do is instead of attaching to the reader, ... > to an OleDbCommand representing your stored procedure. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Newbie Question on parameters passed to stored procedure
    ... am executing the stored procedure in a transaction. ... want the transaction to be live even after executing the procedure. ... "Cor Ligthert" wrote: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... Thanx Brian... ... message something to do with an exception on ole32.dll... ... deleting and rewriting the stored procedure, ... This is the first time that I've used 'refresh'... ...
    (borland.public.delphi.database.ado)
  • Re: ADO faster than ADO.net ?
    ... Brian ... "Cor Ligthert" wrote: ... > 'Test inserting 30000 records into an Access database table using ADO.net ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO faster than ADO.net ?
    ... Brian ... "Cor Ligthert" wrote: ... > 'Test inserting 30000 records into an Access database table using ADO.net ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)