RE: [firebird-support] Efficient update on small subset of LARGE table?

2012-12-13 Thread Svein Erling Tysvær
You could try something like (not tested): EXECUTE BLOCK AS DECLARE VARIABLE MyDbKey char(8); BEGIN for select LrgTbl.rdb$db_key from LargeTable LrgTbl inner join Uppgiftshållare UH on UH.ECO_ID = LrgTbl.Hållare inner join Uppgiftshanterare Uhant on Uhant.ECO_ID =

Re: [firebird-support] Efficient update on small subset of LARGE table?

2012-12-13 Thread Kjell Rilbe
Svein Erling Tysvær skriver: You could try something like (not tested): EXECUTE BLOCK AS DECLARE VARIABLE MyDbKey char(8); BEGIN for select LrgTbl.rdb$db_key from LargeTable LrgTbl inner join Uppgiftshållare UH on UH.ECO_ID = LrgTbl.Hållare inner join Uppgiftshanterare Uhant on

SV: [firebird-support] System performance issue

2012-12-13 Thread Poul Dige
Could it be the old Windows save point problem that Windows, on file access, makes a complete backup of the firebird file? Poul Dige (Sorry for the formatting but Outlook has its own ways...) Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Robert

Re: [firebird-support] Re: How to insert and see an image or photography?

2012-12-13 Thread W O
Thank you very much Thomas. Are you the author of SQL Workbench? Congratulations, very good job!!!. Greetings. Walter. On Wed, Dec 12, 2012 at 7:44 PM, Thomas ijfqsftge...@spammotel.com wrote: ** --- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote: W O wrote: I

[firebird-support] Linux init script fix

2012-12-13 Thread Rick Debay
https://bugzilla.redhat.com/show_bug.cgi?id=886578 The file /etc/init.d/firebird-superclassic was incorrect. We (James Calfee) reported a bug against the EPEL firebird-superclassic.x86_64 package and Redhat patched it.

[firebird-support] Re: Redirection

2012-12-13 Thread mariuz
--- In firebird-support@yahoogroups.com, gu1tarrr tiagofdf.86@... wrote: Hi, I´m using Firebird version 2.1.0.17798 and I'm trying to use redirection feature by enabling it in firebird.conf file. I'm using BDE (Borland Database Engine) to connect to database. I use SERVER NAME string like

[firebird-support] Re: Redirection

2012-12-13 Thread gu1tarrr
--- In firebird-support@yahoogroups.com, mariuz mariuz@... wrote: --- In firebird-support@yahoogroups.com, gu1tarrr tiagofdf.86@ wrote: Hi, I´m using Firebird version 2.1.0.17798 and I'm trying to use redirection feature by enabling it in firebird.conf file. I'm using BDE

[firebird-support] System performance issue

2012-12-13 Thread Robert martin
Hi One of our clients has a machine where intermittently the system crawls to almost stop. Launching programs (like paint) takes about 2 minutes to open. The CPU usage is low (1-3 %) but HDD usage shows at between 97 - 100%. This situation can last 30 mins to 2 hrs before returning to

RE: [firebird-support] Efficient update on small subset of LARGE table?

2012-12-13 Thread Leyne, Sean
Kjell, I would hope that the new approach would takes 2X natural scan. How would that performance be? What new approach are you referring to? SL The approach I was thinking about suggesting. 2 X time for natural scan would be fair enough. It took 1½ hour to execute an update using

[firebird-support] Lost database ...

2012-12-13 Thread Lester Caine
Moving to the right list for some follow up ... Having been running Firebird for many years without a single problem, I've just lost a database! Firebird 2.5.1 on Linux Went to back up the database so I could move it over to another machine to work on. I got an error page 1 is