Once upon a time, RDBMS performance was assessed in terms of MILLIONS of transactions per second (tho these benchmarks have since fallen out of favour I think), but in any event, 5 per second really shouldn't be stretching any modern RDBMS at all I wouldn't think.
But, I guess it depends on what those transactions consist of. -----Original Message----- From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of John Bird Sent: Thursday, 22 July 2010 12:30 To: NZ Borland Developers Group - Delphi List Subject: [DUG] Firebird transactions 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@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe