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