Re: ADO.net Code contest

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

William (Bill) Vaughn wrote:

> Try beginning a transaction before these updates and see what
> happens. As it is JET won't write these rows to the database until
> it's "idle" so it's not really measuring anything except moving rows
> to JET's database cache in memory. When uploading to SQL Server (and
> not using BCP) we roll our own INSERT statements and fill in the
> values using string replacement tags. However, I expect the
> Parameter approach is going to fare well against the raw INSERT
> technique since you can't batch them in JET. You might also try
> executing the INSERT asynchronously and do the prep work while you're
> waiting.

Ah , that's why starting a transaction before the dataset write
started was saving 7-8 seconds! I already wondered why on earth it
could be faster when it was in a transction...

FB


--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.

Relevant Pages

  • Re: Deleting a record
    ... We did originally have problems with two co-operating processes where although ProcessA had written a set of rows (in a transaction), ProcessB couldn't see any of them until some short time later. ... to be any way to force the updates to be immediately flushed TO disk, rather this "RefreshCache" forces subsequent accesses to actually read FROM the disk tables ... There is at least one method of forcing Jet to immediately flush all updates ...
    (borland.public.delphi.database.ado)
  • Re: Do Transactions guard against corruption?
    ... into one, that is called replication. ... But Jet replication does not use ... In replication or a multi-user database? ... they are not locked out as soon as the transaction also append ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do Transactions guard against corruption?
    ... the Jet programmer's guide says explicitly that they are *not* ... Furthermore, with a log, when the transaction is committed, the ... the modifications occur in the same database with the data, ... from WITHIN the transaction (locks don't do lock ...
    (microsoft.public.access.modulesdaovba)
  • Re: Deleting a record
    ... Is there a way to refresh the Access table using a query? ... although ProcessA had written a set of rows (in a transaction), ... FROM the disk tables ... exposed by the Microsoft Jet OLE DB provider called "JET OLEDB:Transaction ...
    (borland.public.delphi.database.ado)
  • RE: runtime error again
    ... > I get this error msg. ... > running WinXP Home SP2 and all available updates ... > Jon Erlandson posted and suggested I run MDAC component checker and check ... I am current on the MD Jet ...
    (microsoft.public.windowsxp.general)