Thank you, much appreciated.
cessor for
Firebird 3.03 64 bits database on Windows server 2016 64 bits
> On 19-5-2018 15:00, fabia...@itbizolutions.com.au [firebird-support]
> wrote:
>> We are trying to define the best specs for a windows based Firebird 3 64
>> bits instance.
>>
>> Based on our
We are trying to define the best specs for a windows based Firebird 3 64
bits instance.
Based on our knowledge, and the type of applications running we know we will
need the best possible performance for 1 to 10 concurrent users demanding
queries (reading not writting) from just a few relationa
16, 2018 7:10 PM
Subject: Re: [firebird-support] Bulk upload options
> 16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote:
>> Does anyone have experience with bulk updates via isql? Would it be X
>> times faster than using a normal application inserting the r
dnesday, May 16, 2018 7:10 PM
Subject: Re: [firebird-support] Bulk upload options
> 16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote:
>> Does anyone have experience with bulk updates via isql? Would it be X
>> times faster than using a normal application inse
emp.txt has data in fixed length format):
INSERT INTO MY_REAL_TABLE(ID, NAME)
SELECT ID, NAME FROM BCP_DATA;
I think this solutions will do
- Original Message -
From: "fabia...@itbizolutions.com.au [firebird-support]"
To:
Sent: Wednesday, May 16, 2018 12:43 PM
Subj
I am looking for the fastest way to run a bulk insert.
I believe one way would be using isql.exe , I need to plan a solution to
upload into a single table around 500 million records. Does anyone have
experience with bulk updates via isql? Would it be X times faster than using a
normal applicat
Hi All
Our production server is a Win 64 massive ram memory Firbierd 3 64bits, and
our development server is a VM on Win 32 with Fb 3 (32 bits)
When we backup the database from the production x64 server, and try to
retore it on the win32 server we usually get the following message:
Attempt to
Anto
Each "request" to the database is managed by one CPU, and 6 CPU will be used
in full when 6 concurrent requests are passed to Firebird, however to get
Firebird to process each request with all available CPUs is not possible at
the moment, it would require a re-write of Firebird.
Regards
F
Are you trying to store details of the American public debt? or the world's
public debt? Just kiding Not
How about assigning another integer field to each record with a value
representing the "segment" for the value you are trying to store, and then
use an index on that value, I'll explain
Just wondering can my app start a transaction with Begin Transaction and
then call a stored procedure that contains the SUSPEND sentence at the end
while the transaction is still opened? Is there any special consideration
when comencing a transaction other than to ensure the process finished as
SOLVED - Changed code to use explicit transactions and the problem went
away, so I guess implicit transactions was "keeping the transaction opened"
for a few extra milliseconds... while the other "process / thread / or ODBC
object" was trying to read the data added by the last transaction, and a
We have a multithreaded app written in Clarion 9 (win32), running on several
win 2012 64 bits r2, connecting to Firebird 3 (latest build) via ODBC 32
bits (latest ODBC). We are experiencing a rare propblem, that happens not
very often. The issue is as follows:
The application does not use "begi
We are trying to configure and package Firebird 3 as an embedded database
with our App. Could someone provide an example of how to do it please? We
have configured Firebird to work as embedded locally but we need to ship all
files into one directory with our app, and don't know what files are ne
Hi Guys
We are considering encrypting the DB, we are on FB 3 on top of Windows 2012
R2 64 bits, the options we have are:
1) Do what we did with FB2, that is encrypt the DB folder with the same user
account as the firebird service was running on, and nevel login with that
user. That is an OS fi
Thanks Vlad
- Original Message -
From: "hv...@users.sourceforge.net [firebird-support]"
To:
Sent: Wednesday, September 21, 2016 6:00 AM
Subject: [firebird-support] Re: Nbackup restored database size is 50 Mega
shorter than original DB
>> ---In firebird-support@yahoogroups.com, wrot
We noticed the results of restoring with NBackup a 7 Gb database is 50
megabytes shorter in size than the original DB. Is this a problem? Or it
does not matter? Both Db are equal?
What we did it:
Execute Nbackup level 0, then 1 and then 2 on a DB seating with no people
connected to it.
The exe
This is a message to the development team, including all testers,
documenters, project management, etc
After almost 14 years using Firebird (from version 1 candidate release 3)
until today, with FB 3 migration just finalized on Tuesday night this week,
with 3 databases (100Mb, 7GB and 70Gb) ser
Ahhh, OK, thanks!!
ar.nl [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Sunday, September 11, 2016 5:11 PM
Subject: Re: [firebird-support] "nbackup needs local access to database file"
On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I am getting this e
abian
- Original Message -
From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Sunday, September 11, 2016 5:09 PM
Subject: Re: [firebird-support] Gbak performance issues on FB3
On 10-9-2016 22:11, fabia...@itbizolutions.com.au [fir
running as embebed and
it is a superserver with active network connections.
Any ideas?
- Original Message -
From: fabia...@itbizolutions.com.au [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Sunday, September 11, 2016 6:11 AM
Subject: [firebird-support] Gbak p
I am running both gbak.exe and nbackup.exe on an FB3 server with Windows 2012
R2 64 bits, 24 processor, 192 GB ram, the nbackup.exe level zero is much faster
than the gbak.exe (does not make any sense, it should take about the same time
as gbak), both running locally but connecting using the sup
To Make it perfectly clear, the following statment works:
gbak -b -v -z -user SYSDBA -pas Hello-2 -T localhost:DB_FB3.fdb c:\Temp\DB.Fbk
And the following DOES NOT work:
gbak -b -v -z -user SYSDBA -pas 'Hello-2 -T' localhost:DB_FB3.fdb
c:\Temp\DB.Fbk (note the quotes enclosing the password)
while the database is been backup with gbak
10.09.2016 17:10, fabia...@itbizolutions.com.au [firebird-support] wrote:
> what can I do to run a 24x7 system and have backups every so often without
shutting down
> the system for a few minutes?
Don't ever use embedded connec
: Sunday, September 11, 2016 1:19 AM
Subject: Re: [firebird-support] "File Database is not found" error appears
while the database is been backup with gbak
10.09.2016 17:10, fabia...@itbizolutions.com.au [firebird-support] wrote:
> what can I do to run a 24x7 system and have bac
Hi
I just upgraded to FB 3 and the server has a task scheduled after midnight to
execute gbak for all 3 databases on the server.
I've noticed the database connection attempts fail during the gbak execution.
Is this a new "restriction" on gbak FB3?
The specifics:
gbak with version WI-V3.0.1.325
Ahhh, the security.fdb is the issue, I only kept the cfg files
Thanks Helen
Regards
Fabian
- Original Message -
From: Helen Borrie hele...@iinet.net.au [firebird-support]
To: fabia...@itbizolutions.com.au [firebird-support]
Sent: Thursday, September 08, 2016 10:19 AM
Subject
last night as Dimitry explained and
FB seems fine)
Regards
Tony
On 08/09/2016 9:23 AM, fabia...@itbizolutions.com.au [firebird-support] wrote:
After replacing the existing install with the snapshot I am getting the
following error on connection:
Connecting... F
After replacing the existing install with the snapshot I am getting the
following error on connection:
Connecting... Failed!
Unsuccessful execution caused by a system error that precludes successful
execution of subsequent statements.
Install incomplete, pl
@yahoogroups.com
Sent: Wednesday, September 07, 2016 11:06 PM
Subject: Re: [firebird-support] Re: Problems after FB3 upgrade
07.09.2016 14:23, fabia...@itbizolutions.com.au [firebird-support] wrote:
> Would you recommend installing the latest snapshot, or stay with the
released FB3 vers
Hi All
We are going live with the upgrade to FB3 this comming Friday night. Would you
recommend installing the latest snapshot, or stay with the released FB3
version? I have read some posts mentioning an issue with "invalid transaction
handle" and would like to avoid getting my customer into sh
Would it be possible that the original update triggered a second update on the
same record, hence the value of new and old are the same? For instance a
trigger after update calls a procedure to update the same record, the first run
of the trigger will have old <> new, but perhaps on the second r
Hello
It is my understanding that the difference in performance is not as in previous
versions because the server model has been changed to have multiple processors
to attend to multiple requests, however each request is only served by one
processor. In other words the FB3 server can assign eac
Hi All
This may not be the right place to ask, I have prepared a tool that optimazes
and automates the backup for Firebird Databases, providing a backup almost up
to the last minute for large production databases (That was the aim when we
planned it). I would like tomake it available to other F
Hi Martin
Now the error is regarding the user and password, that is good news, the engine
trying to grab the DB is the superserver, not the local embedded.
Now regarding the user and password, there are big changes in FB3 with
security, can I recommend you read the release notes where it explain
Hi
I think what is happening is the gbak is trying to access the database using
the embedded engine, and it cannot do so because there are other superserver
users accessing it via remote access. I think you need to change the gbak
sentence to refer to the database as a remote or loopback datab
-
From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Wednesday, June 15, 2016 6:56 PM
Subject: Re: [firebird-support] Engine12 mistery
14.06.2016 22:46, fabia...@itbizolutions.com.au [firebird-support] wrote:
> It seems Engine12
ngine12 mistery
On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support]
wrote:
> My understanding from reading the documentation is:
>
> Provider = Remote means the client is on the network, excluding
> 127.0.0.1
> Provider = Loopback means the cli
My understanding from reading the documentation is:
Provider = Remote means the client is on the network, excluding 127.0.0.1
Provider = Loopback means the client is actually on the same OS instance as the
FB3 engine, and it is using the 127.0.0.1 to access the database to avoid the
"embedded se
So it is a required part of Firebird 3.
Mark
- Bericht beantwoorden -
Van: "fabia...@itbizolutions.com.au [firebird-support]"
Aan:
Onderwerp: [firebird-support] Engine12 mistery
Datum: di, jun. 14, 2016 19:36
Hi All,
Is there a reason why the FB 3 se
Hi All,
Is there a reason why the FB 3 server configured as follows would require
Engine12 as a provider?
DatabaseAccess = None
AuthServer = Srp
AuthClient = Srp
UserManager = Srp
Providers = Remote
WireCrypt = Enabled
WireCompression = false
ServerMode = Super
I've noticed the network
I'll answer myself for 2)
2) page 42 of
http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf
1) and 3) remain a question
Cheers
Fabian
- Original Message -
From: fabia...@itbizolutions.com.au [firebird-support]
To: firebird-su
Now that I have the production candidate FB 3 server up and running I am doing
some fine tunning, and there a few questions I'd like to ask:
1) The variable "RemoteBindAddress" in firebird.conf is a Server Wide value, or
it can be set per database in databases.conf?
2) The "WireCompression" vari
inmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
>
> Cheers,
> Fabian
>
> ----- Original Message -
> From: fabia...@itbizolutions.com.au [firebird-suppor
Hi Helen
I understand, I have read the comments, we are reffering to two different
things, I mean the sentence in step 2) not further ahead, the sentence as
placed on the Release Notes to execute the isql program fails to execute unless
it contains the passowrd. What I am referring to is perha
tence works probably on Linux but on
Ms WIn 2012 Server R2 it requires the password to run.
Cheers,
Fabian
- Original Message -
From: fabia...@itbizolutions.com.au [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Monday, June 13, 2016 4:34 AM
Subject: [firebird-su
Hi All,
I have configured the FB 3 server to only accept SRP connections and need to
add a new User to the security DB, I read GSEC is not the way, and I have tried
with isql but for some reason I am not having luck, I am trying the following:
I created a script into a file as follows:
SET S
FB 3.0
64bit is to small?
02.06.2016 15:12, fabia...@itbizolutions.com.au [firebird-support] wrote:
> the limit remains as in FB 2.5, meaning you cannot enter a value above
131071 pages , now
> I don't know if the bug is on IBExpert, or if Firebird 3.0 rejects the
value.
T
Anto
Could you let me know how you setup the DB cache value? I mean what tool or
sentence are you using to set it and then check it, because I am having trouble
setting the value above 131071 pages with IBexpert, probably an IBExpert bug,
but I just want to be sure it is not something else,
T
Hi Vlad,
What I've noticed is that using the latest IBexpert, and configuring the DB
cache pages via IBexpert, the limit remains as in FB 2.5, meaning you cannot
enter a value above 131071 pages , now I don't know if the bug is on IBExpert,
or if Firebird 3.0 rejects the value.
Cheers,
Fabian
of FB accidentally?
Thanks
Rob
On 2/06/2016 11:12 a.m., fabia...@itbizolutions.com.au [firebird-support]
wrote:
Dmitry
Something funny is going on regarding the memory consumption, I have
attached screenshots showing the memory counters. If you look at the process
itself
Dmitry
Something funny is going on regarding the memory consumption, I have attached
screenshots showing the memory counters. If you look at the process itself
(file TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it only consumed 2
GB. If you look at Windows Task Manager (file
TaskManage
Hi Dmitry
I am progressing with solving this one, the first issue was related with a
config variable reserving most of the ram upfront, hence there was no ram
available for the DB cache. The second issue was misinterpreting what the
following meant:
# File system cache size
# Note that the low
Vlad
Thank you, english is not my first language, I interpreted the sentence as "go
calculate the total amount of ram, then set the value as a number within such
percentage of your ram...", but thanks for the clarification. Perhaps to avoid
other users making the same mistake each configurable
Dimitry
That is my concern, on FB 2.5 I was able to see the memory allocated as soon as
the first connection is granted to the DB, but on FB 3 I am not seeing almost
any memory been allocated what makes me believe that something is not right.
However as more users connect and use the DB, the me
fabia...@itbizolutions.com.au [firebird-support]
firebird-support@yahoogroups.com:
Hi All
We are having trouble setting up the database cache size on FB 3.0
running on Windows 2008 R2 64 bits with 32 GB ram.
The problem we have is we cannot get the server to allocate th
Hi All
We are having trouble setting up the database cache size on FB 3.0
running on Windows 2008 R2 64 bits with 32 GB ram.
The problem we have is we cannot get the server to allocate the ram for
the cache as we intend. With FB 2.54 we had the DB cache set very high,
close to 1 GB per databas
Hi Again
We are about to upgrade from Windows 2008 FB 2.54 64 bits into Windows
2012 R2 FB 3.0 64 bits, and would appreciate comments from experienced
DB administrators. We use FB as the main DB, and we access it via 32 bit
native ODBC (the latest version of Firebird ODBC).
I would appreciate
Firebird 3 ready for Production?
24.05.2016 18:38, Fabian Ernesto Chocron fabia...@itbizolutions.com.au
[firebird-support]
wrote:
> And regarding the replication, any advise on what product may be the right
choice?
I would recommend to look at IBPhoenix Replicator.
h
5, 2016 at 1:11 PM, fabia...@itbizolutions.com.au
[firebird-support] wrote:
Now on the flip side, the performance sucks, it is worst than with FB
2.54, and when looking at the task manager on windows it appears only one
processor it doing the job, as if the code was not SMP enabled
...@itbizolutions.com.au [firebird-support] wrote:
> Do you know if it is planned for Firebird to distribute each client request
across all
> CPUs? When?
Parallel execution of a single request is not planned at all yet.
--
W
Re: [firebird-support] Is Firebird 3 ready for Production?I see, will read it
Cheers
Fabian
- Original Message -
From: 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
To: fabia...@itbizolutions.com.au [firebird-support]
Sent: Thursday, May 26, 20
,
Fabian
- Original Message -
From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Thursday, May 26, 2016 6:01 PM
Subject: Re: [firebird-support] FB 3 - SMP switched off ?
25.05.2016 19:34, fabia...@itbizolutions.com.au
ebird-support@yahoogroups.com
Sent: Thursday, May 26, 2016 4:53 AM
Subject: Re: [firebird-support] Re: Is Firebird 3 ready for Production?
On Wed, May 25, 2016 at 1:11 PM, fabia...@itbizolutions.com.au
[firebird-support] wrote:
Now on the flip side, the performance sucks, it is worst
Hi All
First of all CONGRATS to all developers for the 3.0 project, the Firebird DB
engine has been an excelent tool for us for more than a decade, and we do
appreciate the efforts and great product the developing team has created!
Specifically to the SMP capable feature, we are not sure
Thanks Alexey, will try it and post back with comments
- Original Message -
From: Alexey Kovyazin a...@ib-aid.com [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Thursday, May 26, 2016 6:58 AM
Subject: Re: [firebird-support] Is Firebird 3 ready for Production?
Hi Alexey
Thank you for the comments. So far everything has gone ok, I fixed all the
fields with ASCII charset at the FB 2.54 DB (changed the domain to charset
NONE), and now the backup and restore workes fine, with no errors.
I've noticed the new FB3 DB has now two SYSDBA users, one seems
08 AM
Subject: Re: [firebird-support] FB 3 issues with String from FB 2.54
On 23-5-2016 03:45, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and
> after hitting a string related error for some time i have
Hi Kjell
We had a FB 2.54 DB with a few varchars defined as charset ASCII, the
intention was to stop users from entering unreadable characters, so the charset
was there to attempt to filter garbage, at least that was the idea), anyways we
converted all domains from charset ASCII to NONE, and
Pete
Thanks for your input.
We managed to get the DB upgraded to 3.0 (removed all charset ASCII
definitions on fields while on 2.54, then backup the DB and restored it on 3.0,
and it all worked). Now on the flip side, the performance sucks, it is worst
than with FB 2.54, and when looking
Hi All
We have a multi-user, multi-company, cloud based system running with
Firebird 2.54 as the main database, with about 100 concurrent connections.
We are considering migrating to FB 3.0 to take advantaje of the SMP
architecture, we have a 32 core / processors server, so we are hopping to
liviuslivius liviuslivius poczta.onet.pl [firebird-support]
yahoogroups.com> writes:
>
>
>
>
>
>
> hi,
>
> will be good to know which charsets did you tried. utf8, none,
octets...
>
> but remember to connet to db also with this charset settings
>
> regards,
> Karol Bieniaszewski
> ---
Hi All
I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and after
hitting a string related error for some time i have got to the point where I do
understand the issue, but I don't know how to solve it. The issue is pretty
simple, the FB 2.54 DB contains a few characters t
74 matches
Mail list logo