<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi<br>
<br>
Definately an issue elsewhere. No matter how slow your computer is any
ACID compliant DB should not corrupt your DB as described. it is
likely at the client end sending the same transaction twice as you say.<br>
<br>
AFAIK commiting should immediately make the transaction viewable to
other transactions (that start after yours finishes or are set to
readCommited (I think) ).<br>
<br>
Cheers<br>
Rob<br>
<span style="font-size: 10pt; font-family: Arial;" lang="EN-NZ"><o:p></o:p></span>
<div class="moz-signature">
<div class="Section1">
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(255, 153, 0);" lang="EN-NZ"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="" lang="EN-NZ"><o:p> </o:p></span></p>
</div>
</div>
<br>
On 22/07/2010 2:51 p.m., John Bird wrote:
<blockquote cite="mid:E4AD834B634D4A629EAF906816296FA7@JohnSony2"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.7600.16588">
<style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
<div><font size="2" face="Arial">Each transaction fires a inserts one
line in one table and populates about 20 fields, and inserts multiple
lines in another with similar number of fields. And multiple of
these transactions are coming from the slow Windows 2000 box each
second in this burst.</font></div>
<div> </div>
<div><font size="2" face="Arial">Within each transaction the program
fires the generator once for ID for one table, and once for each line
ID of the other table, and writes one line to a log file after the
transaction commits. The generator is being fired separately for the
occasional duplicate transactions (ie they have different ID's even
though other fields are the same) yet only one line appears in the log
file. Hence the mystery!</font></div>
<div> </div>
<div><font size="2" face="Arial">So in answer to what you asked, it
is several transactions per second, each involving inserts into two
tables.</font></div>
<div> </div>
<div><font size="2" face="Arial">From what everyone is implying it
looks like Firebird should not be the culprit with this volume on a
fast server unless an extremely slow workstation can slow any of the
transactional stuff down..... This is good, mainly wanted to
eliminate the Firebird server as a area to investigate.</font></div>
<div> </div>
<div><font size="2" face="Arial">Practical question - if I want to
do a query on the transaction ID after it is finished is it visible the
exact instant after the commit transaction is done, or may there any
lag while Firebird does its housekeeping - or while some cached stuff
on the slow workstation is not saved yet?</font></div>
<div> </div>
<div> </div>
<div><font size="2" face="Arial">John</font></div>
<div><br>
</div>
<div
style="font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
<div
style="background: rgb(245, 245, 245) none repeat scroll 0% 0%; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">
<div style=""><b>From:</b> <a moz-do-not-send="true"
title="Cameron.Hart@flowsoftware.co.nz"
href="mailto:Cameron.Hart@flowsoftware.co.nz">Cameron Hart</a> </div>
<div><b>Sent:</b> Thursday, July 22, 2010 1:56 PM</div>
<div><b>To:</b> <a moz-do-not-send="true"
title="delphi@delphi.org.nz" href="mailto:delphi@delphi.org.nz">NZ
Borland Developers Group - Delphi List</a> </div>
<div><b>Subject:</b> Re: [DUG] Firebird transactions</div>
</div>
</div>
<div><br>
</div>
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125); font-size: 11pt;">Is
transaction the right term? Or do you really mean records – ie you are
inserting 5 records per second for 20-30 seconds.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125); font-size: 11pt;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125); font-size: 11pt;">Running
a series of insert statements (within one transaction) against firebird
I can get up to 2500 per second on a laptop alone.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125); font-size: 11pt;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family: 'Calibri','sans-serif'; color: rgb(31, 73, 125); font-size: 11pt;"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span
style="font-family: 'Tahoma','sans-serif'; color: windowtext; font-size: 10pt;"
lang="EN-US"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span
style="font-family: 'Tahoma','sans-serif'; color: windowtext; font-size: 10pt;"
lang="EN-US">From:</span></b><span
style="font-family: 'Tahoma','sans-serif'; color: windowtext; font-size: 10pt;"
lang="EN-US"> <a moz-do-not-send="true"
href="mailto:delphi-bounces@delphi.org.nz">delphi-bounces@delphi.org.nz</a>
[<a class="moz-txt-link-freetext" href="mailto:delphi-bounces@delphi.org.nz">mailto:delphi-bounces@delphi.org.nz</a>] <b>On Behalf Of </b>John Bird<br>
<b>Sent:</b> Thursday, 22 July 2010 1:27 p.m.<br>
<b>To:</b> NZ Borland Developers Group - Delphi List<br>
<b>Subject:</b> Re: [DUG] Firebird transactions<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span
style="font-family: 'Arial','sans-serif'; font-size: 10pt;">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.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-family: 'Arial','sans-serif'; font-size: 10pt;">John</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Hi<br>
<br>
FB should easily handle this. What is your error?<br>
<br>
Cheers<br>
Rob <o:p></o:p></p>
</div>
<div>
<div>
<p style="" class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><br>
On 22/07/2010 12:30 p.m., John Bird wrote: <o:p></o:p></p>
<pre>Dealing with a timing issue involving Firebird, probably the cause is a slow <o:p></o:p></pre>
<pre>workstation running the processing program.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>The workstation occasionally sends a burst of transactions, each involving <o:p></o:p></pre>
<pre>adding new records to the same two tables. I presume Firebird can handle <o:p></o:p></pre>
<pre>this<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>The server is a FAST quad core Windows 2003 server running Firebird 2.0 - it <o:p></o:p></pre>
<pre>should handle a burst of transactions at up to 5 per second for up to 20 or <o:p></o:p></pre>
<pre>30 seconds?<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>John <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>NZ Borland Developers Group - Delphi mailing list<o:p></o:p></pre>
<pre>Post: <a moz-do-not-send="true"
href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><o:p></o:p></pre>
<pre>Admin: <a moz-do-not-send="true"
href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><o:p></o:p></pre>
<pre>Unsubscribe: send an email to <a moz-do-not-send="true"
href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre> <o:p></o:p></pre>
<div style="text-align: center;" class="MsoNormal" align="center">
<hr align="center" size="2" width="100%"></div>
<p class="MsoNormal">_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a moz-do-not-send="true" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a moz-do-not-send="true"
href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a moz-do-not-send="true"
href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a>
with Subject: unsubscribe<o:p></o:p></p>
</div>
<p>
</p>
<hr>_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a class="moz-txt-link-abbreviated" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a class="moz-txt-link-freetext" href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
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 wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>
</body>
</html>