Re: [firebird-support] NBackup level 0 vs. file copy?

2013-10-08 Thread Konstantin Khomoutov
On Tue, 8 Oct 2013 12:37:57 +0200 Kjell Rilbe kjell.ri...@datadia.se wrote: Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0 perform compared to a high-performance copy utility like FastCopy? I'm asking because my DB is 80+ Gbyte and both the database and the backup are

[firebird-support] Choice of index

2013-10-08 Thread Tim Ward
The query is select [some columns] from MYTABLE where FIELDONE= 2 and FIELDTWO 2 order by [some columns] Most of the time most records have FIELDONE = 2 and FIELDTWO = 2, so this query is looking for what are normally a small number of exceptions, and one of my objectives is to

Re: [firebird-support] Overflow occurred during data type conversion

2013-10-08 Thread Net Firebird
my procedure code is as follows. CREATE PROCEDURE SP_GET_MINIWEB_EVENTS ( MINIWEB_NAME NAME, LANGUAGE_CODE LANGUAGE_CODE ) RETURNS ( EVENT_ID ID, EVENT_DATE Date, EVENT_TIME Time, TITLE EVENT_TITLE, DESCRIPTION DESCRIPTION, PRICE MONEY, VENUE VENUE, ADDRESS

[firebird-support] Database error - Bad File Descriptor

2013-10-08 Thread Myles Wakeham
We recently moved a virtual server with a Firebird 1.5 database server (Linux x64 Super Server) from one host to another. We have seen this in the past, although rare (maybe once a month) and a server service restart fixes it. But now we are seeing it daily. This is from the firebird.log

RE: [firebird-support] NBackup level 0 vs. file copy?

2013-10-08 Thread Leyne, Sean
Dmitry, Tuesday, October 8, 2013, 2:37:57 PM, you wrote: KR Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0 KR perform compared to a high-performance copy utility like FastCopy? as I see on my desktop nbackup -b 0 is 2-3 times slower than lock/file copy/unlock. I think