[DUG] Firebird transactions

[Edward Koryagin]

Firebird use versioning for records so you can insert thousands transaction per second as soon as we don't have a lot of triggers which do a lot of other stuff inside.

Edward Koryagin


--- On Thu, 22/7/10, John Bird <johnkbird at paradise.net.nz> wrote:

> From: John Bird <johnkbird at paradise.net.nz>
> Subject: [DUG]  Firebird transactions
> To: "NZ Borland Developers Group - Delphi List" <delphi at delphi.org.nz>
> Received: Thursday, 22 July, 2010, 12:30 PM
> 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
>