Hi,
I have a table LargeTable with ~170 million records. I need to update
a single column on a small subset (maybe a million records or so), but
the subset selection requires references to other tables.
Unfortunately, Firebird does not support joins in update or delete
queries, resulting in
It happened again. Suddenly I lost the ability to locally access a
database. This is firebird 2.1 running on Ubuntu 10.04.
If I try and access the database using isql I get Permission denied.
However, ls -l shows I have ownership and rights to the file. I can
even dump the file. It seems
On Wed, 12 Dec 2012 15:23:53 +0400, Ted Miglautsch theom...@migmar.com
wrote:
It happened again. Suddenly I lost the ability to locally access a
database. This is firebird 2.1 running on Ubuntu 10.04.
If I try and access the database using isql I get Permission denied.
However, ls -l shows
Hi all
Does any one know of a scheduler that uses Nbackup?
There are a couple that use GBak (like FIBS or GBakScheduler etc.) but I
was hoping something similar exists for NBackup
Free, commercial, demo anything
Thanks
Tony
Well, I can save and see the images using a programming language, no
problem with that, but maybe sometimes I can need to save them without a
program and I don't know how to do that.
If there is not solution then there is not solution and I will live knowing
that.
Greetings.
Walter.
On
Well, I can save and see the images using a programming language, no
problem with that, but maybe sometimes I can need to save them without a
program and I don't know how to do that.
If there is not solution then there is not solution and I will live
knowing
that.
Greetings.
Walter.
Thank you very much for your answer Martijn
Greetings.
Walter.
On Wed, Dec 12, 2012 at 8:28 AM, Martijn Tonies m.ton...@upscene.comwrote:
**
Well, I can save and see the images using a programming language, no
problem with that, but maybe sometimes I can need to save them without
Hi,
On 12-12-2012 5:47 PM, W O wrote:
Well, I can save and see the images using a programming language, no
problem with that, but maybe sometimes I can need to save them without a
program and I don't know how to do that.
In Flamerobin, you have the option 'Save blob to file'. But you have to
Hi guys.
Database in one of our clients has reached the point where it is no longer
possible to get results in some reasonable time.
In the database we have two tables: TASK - around 40 million of rows nad
LOCATION around 20 million of rows.
This is the query:
SELECT
T.ID_TASK,
Are all clients connecting using the same protocol? And the same
adress resolution?
Can, at the same time you are being denied the permissions, other
users (re-)connect and work without problems (== is this only a
problem when you are trying to access via SYSDBA or OWNER?
I
This is a FB 1.5.6 bug. It does not appear in our testing for the move
to FB 2.5.2.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Friday, November 09, 2012 4:22 PM
To: firebird-support@yahoogroups.com
Hello,
In the Firebird 2.5.2 release notes it is strongly advised to migrate databases
using gbak backup/restore. or `If this is impracticable, at least rebuild all
compound indices in the databases being migrated.'
What's the reason for this advise, what can go wrong when indexes are not
horushardware wrote:
Copying table: TABLE1
Connecting to: '' as 'SYSDBA'...Connected.
Reading charset: NONE. No need for reconnecting.
Connecting to: '' as 'SYSDBA'...Connected.
Reading charset: NONE. No need for reconnecting.
Disabling triggers...done.
New format detected.
ERROR!
***
Hi, I have a database I've been using for a long time under FB1.5 and
UnicodeFSS (var)chars. Because of the UnicodeFSS, I'm mindful that I'm dealing
with multi-byte chars.
When I process my schema to create this database under Firebird 2.5.2, and
using UTF8 for all my (var)chars, for one
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
Thank you, Jaison.
Greetings.
Walter.
On Wed, Dec 12, 2012 at 9:44 AM, Jaison jaisonkakk...@gmail.com wrote:
**
Hi,
On 12-12-2012 5:47 PM, W O wrote:
Well, I can save and see the images using a programming language, no
problem with that, but maybe sometimes I can need to save them
--- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote:
W O wrote:
I know how to insert an image or photograpy to a table using a programming
language and how to see that image or photography, but I don't know how to
do without a programming language. So, I have two
Robert,
The weird thing is that while the system is slow and the HDD shows at around
100% use in resource monitor, the actually data throughput is about 1 ro 5MB a
sec. This is can be much higher when the system runs normally. This made me
think the HDD might be faulty but all indications
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
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 `server1:server2:database.fdb' and it connects
successfully but when I try to
Hi,
I´m using Firebird version 2.1.0.17798 and Im trying to use redirection
feature by enabling it in firebird.conf file.
Im using BDE (Borland Database Engine) to connect to database.
I use SERVER NAME string like server1:server2:database.fdb and it connects
successfully but when I try to
12.12.2012 14:41, hjcats59 wrote:
In the Firebird 2.5.2 release notes it is strongly advised to migrate
databases using gbak backup/restore. or `If this is impracticable, at
least rebuild all compound indices in the databases being migrated.'
What's the reason for this advise, what can go
Kjell Rilbe skriver:
What new approach are you referring to?
2 X time for natural scan would be fair enough. It took 1½ hour to
execute an update using execute block with for select do update
where the select picked PK:s from a temporary table I filled with a
select like the above.
23 matches
Mail list logo