...@sapo.pt
Sent: Saturday, August 09, 2014 4:30:41 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Hi Edward,
I think you answered yourself, the enumerator uses a trip to the database
: [Firebird-net-provider] Questions with performance metrics
doing large inserts into DB
It's roundtrip per some records (depends on size of data), not each record.
Putting the records into DataTable will not be faster in any way, as it uses
the DataReader internally.
--
Mgr. Jiří Činčura
: Alexander Muylaert-Gelein [mailto:amuylaert_gel...@hotmail.com]
Sent: Friday, August 8, 2014 1:54 AM
To: firebird-net-provider@lists.sourceforge.
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Hi Edward
I'm also coming from a delphi background
interested in speeding things up then :-)
thanks
a
From: emendez...@nc.rr.com
To: firebird-net-provider@lists.sourceforge.net
Date: Fri, 8 Aug 2014 09:41:03 -0400
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Alexander, Thank you for the feedback
@lists.sourceforge.
Objet : Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Hi
Attached some examples of transactions properly set.
If you can put the reader in readonly and the writer in WriteNoUndo, you
gain some speed. But euh, no magic
Hi Edward,
I think you answered yourself, the enumerator uses a trip to the database for
each record.
You should try to break the data in smaller packages (10 for example) and
use a DataAdapter to get the data into DataTable.
If possible also use several transactions (1 per Package) to
Hi,
Any chance to do profiling? I would expect .NET be slightly slower that .NET,
but this is x-times slower. That's weird. But finding the bottleneck might be
helpful.
--
Mgr. Jiří Činčura
Independent IT Specialist
of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Questions with performance metrics
doing large inserts into DB
Hi,
Any chance to do profiling? I would expect .NET be slightly slower that .NET,
but this is x-times slower. That's weird. But finding the bottleneck might be
helpful
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Questions with performance metrics
doing large inserts into DB
Hi,
Any chance to do profiling? I would expect .NET be slightly slower that
.NET,
but this is x-times slower. That's weird
:51:52 -0400
Subject: Re: [Firebird-net-provider] Questions with performance metrics doing
large inserts into DB
Jiri,
I am not familiar with Profiling. Is there one that you can recommend?
Thank you,
Edward Mendez
Also, are there any tests that I can
-Original Message-
From
, August 8, 2014 1:54 AM
To: firebird-net-provider@lists.sourceforge.
Subject: Re: [Firebird-net-provider] Questions with performance metrics
doing large inserts into DB
Hi Edward
I'm also coming from a delphi background (using FIB) and we have ported/are
already porting for 5 years our
To be honest I’ve never really thought about the transaction settings other
than the default. Are there a specific settings I should be using for just
reading “stale” data?
You should start transaction explicitly. Else it's one transaction per command
and in a batch processing that goes out
You should start transaction explicitly. Else it's one transaction per command
and in a batch processing that goes out of hand really quickly.
I agree with you 100%. The part that I hadn't given much thought was the
Isolation levels to pass as the parameter into the transaction object.
I
Hello All,
I have to develop an application that will move old/stale data from certain
tables to another FB DB. We already have an existing application that did
something similar to this, but his application is written using Delphi 5 and we
are a .NET shop and wanted to develop newer
with performance metrics doing
large inserts into DB
Hello All, I have to develop an application that will move old/stale data
from certain tables to another FB DB. We already have an existing application
that did something similar to this, but his application is written using Delphi
5 and we
15 matches
Mail list logo