Tiberiu, consider the comments on COMMIT RETAINING in the quotes from Helen's and Ann's messages below - maybe there's one place where you're running with the...
117577
Jesus Garcia
jegaza@...
Mar 31, 2012 6:02 pm
... I also don't belive in magic, when talking about computer science, but is not a programmer error. I have to say that i have seen it after backup and ...
117576
Thomas Steinmaurer
iblogmanager
Mar 31, 2012 5:37 pm
... Any chance that you guys are running something in a loop with AutoCommit set to True? -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology...
117575
Dmitry Kuzmenko
dkuzmenko
Mar 31, 2012 5:11 pm
Hello, Jesus and Tiberiu! JG> O don't know If is firebird or not but i have had the same JG> problem wiith ibx+delphi+interbase 2009. I have had jumps of 20000...
117574
Mark Rotteveel
mark@...
Mar 31, 2012 4:20 pm
... I disagree, the application (or application developer) should do that (preparing statements every time it needs it). It is the driver and/or connection...
117573
Ann Harrison
annwharrison
Mar 31, 2012 3:59 pm
Hi Norm, Talking about optimizing using histograms - for example, an index on gender is valuable when looking for female professional rugby players, and much ...
117572
Norman Dunbar
normandunbar
Mar 31, 2012 1:43 pm
Hi Ann, ... Hmm, I see what you are saying! I'm a DBA!! ;-) ... Oracle are working their way around to "everything tunes itself" but they are not there yet. A...
117571
Tiberiu Horvath
tiberiu_horvath@...
Mar 31, 2012 1:35 pm
At least I'm not alone . Tiberiu From: Jesus Garcia Sent: Saturday, March 31, 2012 4:20 PM To: firebird-support@yahoogroups.com Cc:...
117570
(no author)
(no email address)
Mar 31, 2012 1:33 pm
his is a multi-part message in MIME format. X-Originating-IP: 212.82.109.207 X-eGroups-Msg-Info: 1:12:0:0:0 From: "Tiberiu Horvath" <tiberiu_horvath@...>...
117569
(no author)
(no email address)
Mar 31, 2012 1:26 pm
his is a multi-part message in MIME format. X-Originating-IP: 77.238.189.196 X-eGroups-Msg-Info: 1:12:0:0:0 From: "Tiberiu Horvath" <tiberiu_horvath@...>...
117568
Jesus Garcia
jegaza@...
Mar 31, 2012 1:20 pm
... O don't know If is firebird or not but i have had the same problem wiith ibx+delphi+interbase 2009. I have had jumps of 20000 transactions, and of course...
117567
Dmitry Kuzmenko
dkuzmenko
Mar 31, 2012 1:09 pm
Hello, Tiberiu! TH> Nothing special. The same app, with the same database, TH> the same amount of activity, works correctly for the same company , TH> from a...
117566
(no author)
(no email address)
Mar 31, 2012 1:01 pm
his is a multi-part message in MIME format. X-Originating-IP: 77.238.189.67 X-eGroups-Msg-Info: 1:12:0:0:0 From: "Tiberiu Horvath" <tiberiu_horvath@...> ...
117565
Dmitry Kuzmenko
dkuzmenko
Mar 31, 2012 12:43 pm
Hello, Tiberiu! Friday, March 30, 2012, 12:13:06 PM, you wrote: TH> which) somehow foods my server. While this client is using my TH> software, somehow the gap...
117564
Mark Rotteveel
mark@...
Mar 31, 2012 10:51 am
... The x'...' is a literal escape. If you use parametrized queries you need to set the bytes in the parameter, however depending on your connection ...
117563
Michael Ludwig
mludwig71
Mar 31, 2012 10:50 am
... Why not try and bisecting the problem down to the smallest query that exhibits the error? That's a proven debugging technique that always works. -- Michael...
117562
Michael Ludwig
mludwig71
Mar 31, 2012 10:45 am
... Sounds like a Microsoft Windows TCP level problem; you probably know that much already. Troubleshooting: Connection Forcibly Closed ...
117561
Svein Erling Tysvær
svein_erling
Mar 31, 2012 10:35 am
... What should normally happen, it that at the OAT/NT gap should increase at first, but then reach more or less a stable state, where you saw the gap...
117560
Michael Ludwig
mludwig71
Mar 31, 2012 10:30 am
... The hexadecimal notation for “binary” strings is for literals. ...
117559
Tiberiu Horvath
tiberiu_horvath@...
Mar 31, 2012 7:03 am
My BIG concern is that my program (Delphi XE with good old IBX components) run with the exactly same release, on 4 different clients generating diferent...
117558
Ann Harrison
annwharrison
Mar 30, 2012 4:16 pm
Norm, ... That way, if the stats are wrong it's the database administrator's fault that the performance is bad. Knowing how to fix that bad performance makes ...
117557
Ann Harrison
annwharrison
Mar 30, 2012 4:07 pm
On Fri, Mar 30, 2012 at 4:13 AM, Tiberiu Horvath ... OK, time for my lecture on OAT and OIT. The OIT is the oldest transaction in the system that did not...
117556
Josef Koke
j.kokes@...
Mar 30, 2012 1:39 pm
... Luckily, the damaged table was one which rarely changes, so I was able to restore it from backup with good results. But I am noting down this suggestion...
117555
Norman Dunbar
normandunbar
Mar 30, 2012 12:34 pm
... I think you give me too much credit there! ;-) ... <SNIP> Good explanation, thanks. That's going to end up in the Firebird Internals manual sometime! I've...
117554
Jack Mills
millsjack14
Mar 30, 2012 12:30 pm
Hi firebird 2.5 on windows XP I have a SP that compiles ok & debugs ok using IBExpert but when I try to run the sp I get error 'Output parameters mismatch' ...
117553
Norman Dunbar
normandunbar
Mar 30, 2012 12:24 pm
... Because I'm a masochist, I'll have a read of that later! ... They are certainly keeping the database simple then. Wonder why they bothered to pay huge sums...
117552
(no author)
(no email address)
Mar 30, 2012 8:44 am
his is a multi-part message in MIME format. X-Originating-IP: 217.146.177.78 X-eGroups-Msg-Info: 1:12:0:0:0 From: "Tiberiu Horvath" <tiberiu_horvath@...>...
117551
Lester Caine
lscesuk
Mar 30, 2012 8:32 am
... Not as curious as switching to IIS in 1999? That is probably a good explanation on why they ended up having to move to Java. Where would their system be...
117550
Thomas Steinmaurer
iblogmanager
Mar 30, 2012 8:29 am
... The Firebird remote protocol isn't really optimized for WAN usage. ... Is the OAT stuck as well? If yes, then you have a long-running active transaction....
117549
Tiberiu Horvath
tiberiu_horvath@...
Mar 30, 2012 8:13 am
Hi all, I have a customer who uses my accounting system, who has a server (FB 2.5.1) and 4 clients, distibuted and connected via Internet to this server....
