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 to expect here. It might be interesting to
profile it though and post the results back.
public static class Transaction
{
Hello there,
can you send me your delphi dotnet project and I can understand what takes 18
seconds-)
I D1, D3, D5, D7 VS2005- VS2013.
I develop mainly in DotNet (RemObjects) and just so happens that, in normal
use, dotnet is better than an application server delphi
Norbert Saint
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