If it was FireBird "not keeping up" then I would expect occasional transactions to be missed, not duplicated. That sounds more like FireBird not having enough to do, so making work for itself just so as to have something to do whilst waiting around for the workstation to get into gear and sent the next piece of real work.
The database equivalent of twiddling it's thumbs. J It sounds more like you have a simple (?) error in the code running on your workstation resulting in it sending duplicate transactions (I am guessing that by "transaction" here you mean an "insert statement", rather than some complex series of DML statements). From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of John Bird Sent: Thursday, 22 July 2010 13:27 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@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
_______________________________________________ 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
