<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML XMLNS:O><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16588"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 bgColor=#ffffff text=#000000
CanvasTabStop="true" name="Compose message area">
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>John</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV>Hi<BR><BR>FB should easily handle this. What is your
error?<BR><BR>Cheers<BR>Rob </DIV>
<DIV class=moz-signature>
<DIV class=Section1>
<P class=MsoNormal><SPAN
lang=EN-NZ><O:P> </O:P></SPAN></P></DIV></DIV><BR>On 22/07/2010 12:30 p.m.,
John Bird wrote:
<BLOCKQUOTE cite=mid:27B18A61A46247EA91BC5DE11E2626FF@JohnSony2 type="cite"><PRE wrap="">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: <A class=moz-txt-link-abbreviated href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</A>
Admin: <A class=moz-txt-link-freetext href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</A>
Unsubscribe: send an email to <A class=moz-txt-link-abbreviated href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</A> with Subject: unsubscribe
</PRE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>NZ Borland Developers
Group - Delphi mailing list<BR>Post: delphi@delphi.org.nz<BR>Admin:
http://delphi.org.nz/mailman/listinfo/delphi<BR>Unsubscribe: send an email to
delphi-request@delphi.org.nz with Subject: unsubscribe</BODY></HTML>