have checked with wait and no wait both dint work could you please, how to set
wait/no wait in back end i.e. in firebird database .I have set in front end for
TransactionBehavior class wait/no wait & both dint work
On Monday, February 23, 2015 3:22 PM, SUKHEN DASS <sukhend...@yahoo.com>
wrote:
update never fails but it fails in insert query. loop run in a single
connection with a new datarows in same query.
On Monday, February 23, 2015 2:51 PM, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
>>please, somone guide me where i am wrong
>>
>> This support list is for the Firebird database. For the .NET
>> providers, you need to subscribe to the firebird-net-provider list:
>> List-Subscribe:
>> <https://lists.sourceforge.net/lists/listinfo/firebird-net-provider>,
>>
>At first glance it sounds like a lock conflict with a wait transaction, which
>is not specific to .net.
>To me this list would seem to be better unless and until it requires .net
>provider specific information.
If it is a lock conflict, then the process would hang on one out of 100 000
records. Using wait transaction(s) for batch processing of 100 000 records may
not be a good idea, in most cases it would be better to return back some error
in a log and continue processing those records that succeed. Though we don't
yet know whether or not it is a lock conflict. I'd recommend Sukhen to change
from WAIT to NO WAIT (if this is an issue) and if this doesn't help, to give us
further information:
Does the update process successfully process some record before taking
extremely long on one record? Does the update process sometimes succeed within
minutes or an hour or two, but then suddenly take over 10 hours? Are you
constructing a new query for every insert/update and use 100000 transactions or
even connections, or do you have one UPDATE OR INSERT statement using
parameters all running inside the same transaction (or even declaring an
external table for the import)?
Set
#yiv8934833318 -- #yiv8934833318ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8934833318
#yiv8934833318ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8934833318
#yiv8934833318ygrp-mkp #yiv8934833318hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8934833318 #yiv8934833318ygrp-mkp #yiv8934833318ads
{margin-bottom:10px;}#yiv8934833318 #yiv8934833318ygrp-mkp .yiv8934833318ad
{padding:0 0;}#yiv8934833318 #yiv8934833318ygrp-mkp .yiv8934833318ad p
{margin:0;}#yiv8934833318 #yiv8934833318ygrp-mkp .yiv8934833318ad a
{color:#0000ff;text-decoration:none;}#yiv8934833318 #yiv8934833318ygrp-sponsor
#yiv8934833318ygrp-lc {font-family:Arial;}#yiv8934833318
#yiv8934833318ygrp-sponsor #yiv8934833318ygrp-lc #yiv8934833318hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8934833318
#yiv8934833318ygrp-sponsor #yiv8934833318ygrp-lc .yiv8934833318ad
{margin-bottom:10px;padding:0 0;}#yiv8934833318 #yiv8934833318actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8934833318
#yiv8934833318activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8934833318
#yiv8934833318activity span {font-weight:700;}#yiv8934833318
#yiv8934833318activity span:first-child
{text-transform:uppercase;}#yiv8934833318 #yiv8934833318activity span a
{color:#5085b6;text-decoration:none;}#yiv8934833318 #yiv8934833318activity span
span {color:#ff7900;}#yiv8934833318 #yiv8934833318activity span
.yiv8934833318underline {text-decoration:underline;}#yiv8934833318
.yiv8934833318attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8934833318 .yiv8934833318attach div a
{text-decoration:none;}#yiv8934833318 .yiv8934833318attach img
{border:none;padding-right:5px;}#yiv8934833318 .yiv8934833318attach label
{display:block;margin-bottom:5px;}#yiv8934833318 .yiv8934833318attach label a
{text-decoration:none;}#yiv8934833318 blockquote {margin:0 0 0
4px;}#yiv8934833318 .yiv8934833318bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8934833318
.yiv8934833318bold a {text-decoration:none;}#yiv8934833318 dd.yiv8934833318last
p a {font-family:Verdana;font-weight:700;}#yiv8934833318 dd.yiv8934833318last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8934833318
dd.yiv8934833318last p span.yiv8934833318yshortcuts
{margin-right:0;}#yiv8934833318 div.yiv8934833318attach-table div div a
{text-decoration:none;}#yiv8934833318 div.yiv8934833318attach-table
{width:400px;}#yiv8934833318 div.yiv8934833318file-title a, #yiv8934833318
div.yiv8934833318file-title a:active, #yiv8934833318
div.yiv8934833318file-title a:hover, #yiv8934833318 div.yiv8934833318file-title
a:visited {text-decoration:none;}#yiv8934833318 div.yiv8934833318photo-title a,
#yiv8934833318 div.yiv8934833318photo-title a:active, #yiv8934833318
div.yiv8934833318photo-title a:hover, #yiv8934833318
div.yiv8934833318photo-title a:visited {text-decoration:none;}#yiv8934833318
div#yiv8934833318ygrp-mlmsg #yiv8934833318ygrp-msg p a
span.yiv8934833318yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8934833318
.yiv8934833318green {color:#628c2a;}#yiv8934833318 .yiv8934833318MsoNormal
{margin:0 0 0 0;}#yiv8934833318 o {font-size:0;}#yiv8934833318
#yiv8934833318photos div {float:left;width:72px;}#yiv8934833318
#yiv8934833318photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8934833318
#yiv8934833318photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8934833318
#yiv8934833318reco-category {font-size:77%;}#yiv8934833318
#yiv8934833318reco-desc {font-size:77%;}#yiv8934833318 .yiv8934833318replbq
{margin:4px;}#yiv8934833318 #yiv8934833318ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8934833318 #yiv8934833318ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8934833318
#yiv8934833318ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8934833318
#yiv8934833318ygrp-mlmsg select, #yiv8934833318 input, #yiv8934833318 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8934833318
#yiv8934833318ygrp-mlmsg pre, #yiv8934833318 code {font:115%
monospace;}#yiv8934833318 #yiv8934833318ygrp-mlmsg *
{line-height:1.22em;}#yiv8934833318 #yiv8934833318ygrp-mlmsg #yiv8934833318logo
{padding-bottom:10px;}#yiv8934833318 #yiv8934833318ygrp-msg p a
{font-family:Verdana;}#yiv8934833318 #yiv8934833318ygrp-msg
p#yiv8934833318attach-count span {color:#1E66AE;font-weight:700;}#yiv8934833318
#yiv8934833318ygrp-reco #yiv8934833318reco-head
{color:#ff7900;font-weight:700;}#yiv8934833318 #yiv8934833318ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8934833318 #yiv8934833318ygrp-sponsor
#yiv8934833318ov li a {font-size:130%;text-decoration:none;}#yiv8934833318
#yiv8934833318ygrp-sponsor #yiv8934833318ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8934833318
#yiv8934833318ygrp-sponsor #yiv8934833318ov ul {margin:0;padding:0 0 0
8px;}#yiv8934833318 #yiv8934833318ygrp-text
{font-family:Georgia;}#yiv8934833318 #yiv8934833318ygrp-text p {margin:0 0 1em
0;}#yiv8934833318 #yiv8934833318ygrp-text tt {font-size:120%;}#yiv8934833318
#yiv8934833318ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8934833318
