Hi,Greetings For The Day.
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table. The insertion will take place if product id does
not exist else record to be update.But inside the loop while executing
ExecuteNonQuery control does not come back wait for 10 hours still not came and
no error message and it happens on random rows not always for the same recrodI
am struck past 7 days i am working googled but no solution Finally i decided to
firebird support team
My project is getting delayed please, help
ThanksSukhen Dass
On Saturday, February 21, 2015 3:55 AM, "Nick Upson n...@telensa.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
so
if I run gbak -g every night I should also run gfix, but if I run gbak without
-g I don't need gfix (but it helps a little) ?
Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
On 20 February 2015 at 18:36, Ann Harrison aharri...@ibphoenix.com
[firebird-support] <firebird-support@yahoogroups.com> wrote:
Thomas,
Gbak backup removes all unnecessary back versions and all rolled back changes,
unless it is run with the -g switch. That switch is provided for those cases
where a database cleanup is not needed. Examples include the case when the
database will immediately be replaced by a restored version, upgrading the ODS,
for example, or when a sweep has just been run.
What gbak does not do that sweep does it change the identity of the oldest
interesting transaction. Unlike the oldest active transaction, the oldest
interesting transaction is not critical for performance, but having it correct
does make things slightly better. The oldest interesting transaction is the
first transaction, still visible in the database, that did not commit. Any data
created by older transactions is known to have been created by committed
transactions. A transaction reading it doesn't have the check the state of the
creating transaction. When accessing data created by a more recent transaction,
the reader must test a bit in a bit vector to determine the state of the
creating transaction. Pretty cheap.
During a sweep, gfix notes the oldest transaction whose work it could not clean
up. At the end of the sweep, that becomes the oldest interesting transaction.
In the absence of the -g switch or the attachment parameter that implements
that switch, any process that reads all the data in a database removes all
unnecessary old or rolled back record versions, either itself or through the
proxy of the garbage collect thread. Only gfix changes the recorded oldest
interesting transaction.
Cheers,
Ann
#yiv6142408587 #yiv6142408587 -- #yiv6142408587ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6142408587
#yiv6142408587ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6142408587
#yiv6142408587ygrp-mkp #yiv6142408587hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6142408587 #yiv6142408587ygrp-mkp #yiv6142408587ads
{margin-bottom:10px;}#yiv6142408587 #yiv6142408587ygrp-mkp .yiv6142408587ad
{padding:0 0;}#yiv6142408587 #yiv6142408587ygrp-mkp .yiv6142408587ad p
{margin:0;}#yiv6142408587 #yiv6142408587ygrp-mkp .yiv6142408587ad a
{color:#0000ff;text-decoration:none;}#yiv6142408587 #yiv6142408587ygrp-sponsor
#yiv6142408587ygrp-lc {font-family:Arial;}#yiv6142408587
#yiv6142408587ygrp-sponsor #yiv6142408587ygrp-lc #yiv6142408587hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6142408587
#yiv6142408587ygrp-sponsor #yiv6142408587ygrp-lc .yiv6142408587ad
{margin-bottom:10px;padding:0 0;}#yiv6142408587 #yiv6142408587actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6142408587
#yiv6142408587activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6142408587
#yiv6142408587activity span {font-weight:700;}#yiv6142408587
#yiv6142408587activity span:first-child
{text-transform:uppercase;}#yiv6142408587 #yiv6142408587activity span a
{color:#5085b6;text-decoration:none;}#yiv6142408587 #yiv6142408587activity span
span {color:#ff7900;}#yiv6142408587 #yiv6142408587activity span
.yiv6142408587underline {text-decoration:underline;}#yiv6142408587
.yiv6142408587attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6142408587 .yiv6142408587attach div a
{text-decoration:none;}#yiv6142408587 .yiv6142408587attach img
{border:none;padding-right:5px;}#yiv6142408587 .yiv6142408587attach label
{display:block;margin-bottom:5px;}#yiv6142408587 .yiv6142408587attach label a
{text-decoration:none;}#yiv6142408587 blockquote {margin:0 0 0
4px;}#yiv6142408587 .yiv6142408587bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6142408587
.yiv6142408587bold a {text-decoration:none;}#yiv6142408587 dd.yiv6142408587last
p a {font-family:Verdana;font-weight:700;}#yiv6142408587 dd.yiv6142408587last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6142408587
dd.yiv6142408587last p span.yiv6142408587yshortcuts
{margin-right:0;}#yiv6142408587 div.yiv6142408587attach-table div div a
{text-decoration:none;}#yiv6142408587 div.yiv6142408587attach-table
{width:400px;}#yiv6142408587 div.yiv6142408587file-title a, #yiv6142408587
div.yiv6142408587file-title a:active, #yiv6142408587
div.yiv6142408587file-title a:hover, #yiv6142408587 div.yiv6142408587file-title
a:visited {text-decoration:none;}#yiv6142408587 div.yiv6142408587photo-title a,
#yiv6142408587 div.yiv6142408587photo-title a:active, #yiv6142408587
div.yiv6142408587photo-title a:hover, #yiv6142408587
div.yiv6142408587photo-title a:visited {text-decoration:none;}#yiv6142408587
div#yiv6142408587ygrp-mlmsg #yiv6142408587ygrp-msg p a
span.yiv6142408587yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6142408587
.yiv6142408587green {color:#628c2a;}#yiv6142408587 .yiv6142408587MsoNormal
{margin:0 0 0 0;}#yiv6142408587 o {font-size:0;}#yiv6142408587
#yiv6142408587photos div {float:left;width:72px;}#yiv6142408587
#yiv6142408587photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6142408587
#yiv6142408587photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6142408587
#yiv6142408587reco-category {font-size:77%;}#yiv6142408587
#yiv6142408587reco-desc {font-size:77%;}#yiv6142408587 .yiv6142408587replbq
{margin:4px;}#yiv6142408587 #yiv6142408587ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6142408587 #yiv6142408587ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6142408587
#yiv6142408587ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6142408587
#yiv6142408587ygrp-mlmsg select, #yiv6142408587 input, #yiv6142408587 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6142408587
#yiv6142408587ygrp-mlmsg pre, #yiv6142408587 code {font:115%
monospace;}#yiv6142408587 #yiv6142408587ygrp-mlmsg *
{line-height:1.22em;}#yiv6142408587 #yiv6142408587ygrp-mlmsg #yiv6142408587logo
{padding-bottom:10px;}#yiv6142408587 #yiv6142408587ygrp-msg p a
{font-family:Verdana;}#yiv6142408587 #yiv6142408587ygrp-msg
p#yiv6142408587attach-count span {color:#1E66AE;font-weight:700;}#yiv6142408587
#yiv6142408587ygrp-reco #yiv6142408587reco-head
{color:#ff7900;font-weight:700;}#yiv6142408587 #yiv6142408587ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6142408587 #yiv6142408587ygrp-sponsor
#yiv6142408587ov li a {font-size:130%;text-decoration:none;}#yiv6142408587
#yiv6142408587ygrp-sponsor #yiv6142408587ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6142408587
#yiv6142408587ygrp-sponsor #yiv6142408587ov ul {margin:0;padding:0 0 0
8px;}#yiv6142408587 #yiv6142408587ygrp-text
{font-family:Georgia;}#yiv6142408587 #yiv6142408587ygrp-text p {margin:0 0 1em
0;}#yiv6142408587 #yiv6142408587ygrp-text tt {font-size:120%;}#yiv6142408587
#yiv6142408587ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6142408587
