[DUG] Firebird transactions

[Cameron Hart]

Is transaction the right term? Or do you really mean records - ie you
are inserting 5 records per second for 20-30 seconds.

 

Running a series of insert statements (within one transaction) against
firebird I can get up to 2500 per second on a laptop alone.

 

 

 

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]
On Behalf Of John Bird
Sent: Thursday, 22 July 2010 1:27 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Firebird transactions

 

The error is same transaction going in twice, each one with different ID
(from the Generator) but otherwise the same.   The generator is fired by
the program,  so looks like its the calling program somehow doing the
same processing twice.  Not helped by the fact that the program is
running these bursts of transactions on an old slow Windows 2000
box...just wanted to eliminate Firebird not keeping up.

 

John

 

Hi

FB should easily handle this. What is your error?

Cheers
Rob 

 


On 22/07/2010 12:30 p.m., John Bird wrote: 

Dealing with a timing issue involving Firebird, probably the cause is a
slow 
workstation running the processing program.
 
The workstation occasionally sends a burst of transactions, each
involving 
adding new records to the same two tables.  I presume Firebird can
handle 
this
 
The server is a FAST quad core Windows 2003 server running Firebird 2.0
- it 
should handle a burst of transactions at up to 5 per second for up to 20
or 
30 seconds?
 
John 
 
 
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
unsubscribe
 
  
________________________________


_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
unsubscribe

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100722/a21788d7/attachment.html