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 <johnkb...@paradise.net.nz> wrote: > From: John Bird <johnkb...@paradise.net.nz> > Subject: [DUG] Firebird transactions > To: "NZ Borland Developers Group - Delphi List" <delphi@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@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
