ecret or can you share it here?
> Set
> Den man. 12. nov. 2018 kl. 14:45 skrev André Knappstein
> knappst...@beta-eigenheim.de [firebird-support]
> :
> Livius,
> thank you.
>
> And: cool! You obviously have hit *something*.
> I learned before on different groups
s.
I'll report back!
thanks,
André
>
> Probably difference in query plans.
> Show query plan for both server versions
> Regards,Karol Bieniaszewski
> Oryginalna wiadomość
> Od: "André Knappstein knappst...@beta-eigenheim.de
> [firebird-sup
Hello all,
for a local conference, Iampreparing a session for a
Firebird beginners' group, to demonstrate the basics of Stored
Procedures and their usage from different clients.
One scenario is about transforming a *slightly* complex sql query into
a selectable stored
> I would first rule out the possibility that the change was not
> committed. Both DDL and gbak are transactional, so not having committed
> the table change would result in that change not being part of the gbak
> backup.
Thank you, Mark.
So, this is not usual and somehow I should be
mit freundlichen Grüßen,
ppa. André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail
conferences
and some available other documentation, and then decide what will be a
good page size for my scenario after the migration.
thanks,
André
=
Ihre Nachricht:
Guten Tag André Knappstein knappst...@beta-eigenheim.de [firebird
, nobody was
currently working on the old hardware, but there still are some 400
fb_inet processes active, which probably added to the inaccuracy.
=
Ihre Nachricht:
03.01.2015 03:08, André Knappstein wrote:
I created a test
Operations (new Server)
Read : 2.247
Writes : 5.960
Fetches: 2.476.240
Marks : 807.922
Operations (old Server)
Read : 8.516
Writes : 6.084
Fetches: 1.602.243
Marks : 582.584
set it higher to use more RAM
according to a hint from experts).
While testing the configuration, nobody is in the network.
Firebird runs on dedicated server (just windows and Firebird).
where to look?
mit freundlichen Grüßen,
ppa. André Knappstein
EDV und Controlling
Thank you for the prompt answer, Sean.
But, no, I have read about this specific one.
And though I am sure I did not fully understand about it yet, since my
biggest database is only 1 GByte I *thought* this would not be a
problem for me.
: 6.084
Fetches: 1.602.243
Marks : 582.584
mit freundlichen Grüßen,
ppa. André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax
Yes, the old system is running.
It *is* the current production system of our company and it looks like
I'll be glad if it holds on a bit longer :-)
Don't know the Crystal Disk Mark.
Will check this out for sure!
Was trying to get some clue from Process Explorer (the former
SysInternals
Hello Vlad,
It is sure Raid 0 with 3 * 600 GB Toshiba SAS. I only installed the
server today. I did not use the LSI Raid BIOS for configuration but
the server view installation kit from the producer. So I will have
to look up stripe size and BBU status.
Next week I will also apply a
Maybe you did some tinkering with the metadata?
sure I did, I created that new table on the database, while the
database was in use by different users. Usually I am not doing this,
but migration writes its own book, sometimes :-)
So, even if none of the existing connections can be
Oops, I forgot index problems could lead to there being NULL or
duplicates in the PK field, so change the above query to:
select
T.F1+0,
T.F2+0,
count(*)
from
T
group by
1, 2
. The old server is Classic Engine, if that should matter.
Thanks in advance!
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon
What I still want to say:
_EXTRA_ _ordinary_ _good_ _sessions_!!!
Thank you, guys!
André
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try
I got a test Execute Statement to work without any arguments and then found
this:-
http://www.firebirdsql.org/refdocs/langrefupd15-psql-execstat.html
They say The argument string cannot contain any parameters. which
is basically what i wanted to do. ie pass a string containing the
and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und
... and since the Interbase format is supported by Firebird
I think I have an idea on why you have problems. From where and
when is the information that Interbase format is supported by
Firebird?
Nevertheless, troubles arise if you have to query the historic
table, making joins with look up tables wich reside in the main
database.
A valid point of course, but not a problem in my case.
I don't have that many lookup tables I'd need to be duplicated.
Often enough I even don't need a
the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und
This is why i have this problems. When i have to debug old programs
i use fb1.5, 2.0 2.1 and 2.5. Everytime I change FB I must remember
to chenge the gds32.dll in system dir.
To change the running FB server i've made me a tool tht stops the
running fb and starts that one that i need.. I would
Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
Unable to complete network request to host 192.168.3.25
Error reading data from the connection.
I would take a copy of OmniPeek, Wireshark or similar and check
network connectivity. In the few cases where I saw this, it always
have been problems with switches or firewalls. Once
item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
If I use a COMPUTED column, any time I use SELECT * FROM
OPS_STOP_REC that column is going to be evaluated. This would end up
doing a lot of I/O in those cases where I don't care about the value
of the computed column.
I'd bet that if you can afford to be careless about specifying the
In creating a new table, how is primary key set to begin at a value other
than 0 or 1?
begin suggests that you plan on some form of auto-incrementing a
value for the primary key field?
If so, I'd say you'll need a generator anyway.
You can set this generator to any (valid) value you
Could I ask how you have implemented the recursion - i.e. in the
client, using a CTE or with a stored procedure?
In this particular case I am not using a recursion in SQL.
I have another scenario where sales items are grouped and the groups'
hierarchy can be changed dynamically by
I have an extra column for the position within one and the same
hiararchy.
Can I ask, do you have a separate 'sort' field so the paragraphs
come out in the right order or are the ID's ordered to support this?
Holy muzzle!
How could I miss that there is a *paper* version of the book?
I somehow kept some of Helen's statements in my mind about how
difficult it would be to organize chapters and all in such a way that
it'd make sense to do a paper version.
I could perfectly follow this
2. Fix aliases.conf *in your Firebird host root directory*: entries should
look like this:
XFILES = C:\DATI\FB\XFILES.FDB
In addition, since Walter wrote he does not have too much experience
with W7 and upwards, you will usually use Notepad.exe to edit the
*.conf files.
It is
. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
this: 25.80
thanks
Francisco José Scheffer
De: André Knappstein knappst...@beta-eigenheim.de
Para: Francisco José Scheffer firebird-support@yahoogroups.com
Enviado: miércoles, 29 de mayo de 2013 10:35
Asunto: Re: [firebird-support] Save decimal data type
The system was working on Windows XP. I am thinking there might be ACL issues
but I'm unsure.
Are you aware that on XP it was still possible to use named pipes for
connection, while in Vista and higher (including Server2012) you
*must* use TCP/IP and need to qualify an IP-Adress
Thanks, Dmitry.
He knows and is already at work in changing the PSQL. The problem was that he
noticed the problem only after a massive rollout.
11.04.2013 16:14, André Knappstein wrote:
great!
Thanks Dmitry!
My friend Jaime will be more than happy that this conf setting will
buy
How does this compare with the experience of others?
Hmmm. A quick calculation shows:
My biggest database is 1/74 of the size of yours.
I need ~5 Minutes to backup a freshly restored database, backup takes
longer if the restore is longer ago (up to 6.5 minutes).
5 * 74 = 370 minutes == 6
Hello, André!
Thursday, April 11, 2013, 2:42:01 PM, you wrote:
How does this compare with the experience of others?
AK Hmmm. A quick calculation shows:
AK My biggest database is 1/74 of the size of yours.
AK I need ~5 Minutes to backup a freshly restored database, backup takes
AK longer if
AK I don't use Services API nor -g in that case.
by some reason or never thought about it?
I wonder, why not to use -g option.
did not know about it when I installed the system.
Now the system is in a don't touch it while it runs mode.
I have been spending some 8 years learning C#, writing
Hi Gang!
I am asking this on behalf of a friend who is intensively using
Firebird.
He recently switched from 2.1.x to 2.5.x because I recommended him to
do so.
As it turns out, he was constantly doing the following:
UPDATE Invoices
SET AmtVal = :nAmtVal
TotTax = AmtVal
great!
Thanks Dmitry!
My friend Jaime will be more than happy that this conf setting will
buy him some time to change the PSQL instead of doing a downgrade to
2.1
11.04.2013 15:51, André Knappstein wrote:
AmI right in telling him that what was working for him in 2.1
properly, but run
much slower. The test workstation is an Intel I5-661 with 4gb of memory and
Windows 7 32-bit.
--- In firebird-support@yahoogroups.com, André Knappstein Knappstein@...
wrote:
If you have enough know-how to manage all the basic linux stuff, then
go with a linux system
instead I resorted to execute block, like this (in general terms, not
adapted to your specific case):
And, yet another option.
I don't know if it's good or bad, but I do this frequently and have no
problems with performance or results.
If this is not a run-once command, but most likely is
I have a table (see below) where I want to combine the two totals
below into the 0304KZ6 total so that I can end up with something like the
second example.
current 0304KZ6 6786.11
0304KZ6RR 3750.41
desired 0304KZ6 10536.52
0304KZ6RR 0.00
Am
The basic issues is that, by default wants to cache all disk pages
and with a 64 bit OS it think it has a huge amount of RAM. So once
all physical RAM has been consumed Windows starts to read/write to
the disk page file, which causes an excessive amount of disk IO and thus
slows the system.
Exporting the .DBF to a delimited text file and then importing using an
external table would be faster?
Walter,
a consultant I know has made very good experience with this.
He was regularly importing DBF tables (level 5 and 7) via ODBC.
I encouraged him to try exporting them to CSV first,
Checkout the releasenotes of 2.5 on the filesystem cache:
http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-fbconf-fscache
Did so before, and did now again.
Did not clearly understand if it is important for Win200_8_x64.
Is that important for
Back in 1994 I was able to insert 1000 rows/secs into a IB database from an
DBF file.
The 1994 DBF format probably still was Level 3. Even Level 4 would not
have been much different from a plain text file, and you would not
need any type of middleware to read them into whateveryouimagine.
My opinion is simple. If
Firebird DB at disk, attached not to RAID - fast
and
Firebird DB at dis, attached to the RAID - slow
then problem is with raid controller configuration.
Other applications can use disk less then Firebird, or
only read, so, the IO of that applications can be much
...
where nfi.registro_id=new.registro_id
assuming that new.registro_id is indeed a new ID (not already
existing in the NFI table), I would expect to get an empty resultset
like you actually do.
The Trigger is BEFORE insert and is operating on the table
Notasfiscaisitens
In case somebody's just reading by and has a clue, don't hold back :-)
For the first time since working with Firebird I'm probably about
losing data.
Here's what I did to successfully break my precious:
- shutdown -f while 1 one user who told he's not working was in fact
still working
How would I best go about trying to fix this?
I forgot some things:
- of course I brought the database online again after backup first
failed.
- users are logging in with explicit usernames and roles. nobody and
no software is using SYSDBA besides me
- database only has 1 file (no limbo
Oh, I expressed that wrong, I think.
What I really meant was (so, no problems with distributed files) and
also non with limbo transactions.
I am not using shadows nor 2-phase transactions.
On Wed, 9 Jan 2013 15:19:43 +0100, André Knappstein
knappst...@beta-eigenheim.de wrote:
- database
after executing all possible combinations of gfix -m, gfix -v
still reports Number of record level errors: 1, and gbak -b -g
-i -v ... still does not get over starting transaction.
I don't have any idea what happened, but suddenly the backup *did*
work. This completely toils
Just curious: why not remain with Crystal Reports, especially if it
seems to be doing all you need? It works very very fine for me.
Good morning!
I am looking for a reporting tool that can run against Firebird and
produce reports that are user executed if possible and can have
parameters
) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
However, there is also a pseudo-role named PUBLIC that you can grant
rights to and all users get the privileges granted to PUBLIC.
plus there was a (bug/feature?) in 1.5 where any user who logged in
with lower case username but with the correct password has been
granted PUBLIC
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
On 03/12/2012 07:06 pm, André Knappstein wrote:
It's not possible the way you describe it. You can't have any group
of users, which are not SYSDBA, automatically privileged for DML as
soon as a relation is created or its metadata was changed.
You need to explicitely grant the privileges
Hmmmh... how embarrassing. Looks like I got it solved.
First of all, replacing -pas by -pass did not solve the problem.
Today I got quite distressed because not any order of the options,
with our without the -y switch, did work. I always received the error
message.
To make a long story
Thank you for the time to explain so well.
I always appreciate your detailed explanations on such topics, be they
historical or technical.
Now it's clear why this exception is filed under deadlock at times.
On Wed, Nov 28, 2012 at 9:42 AM, André Knappstein
knappst...@beta-eigenheim.de wrote
FbTransactionBehavior t_behaviour;
FbTransactionOptions t_options;
t_behaviour = FbTransactionBehavior.NoWait;
t_options.TransactionBehavior = t_behaviour;
FbConnection conn = new FbConnection();
conn.BeginTransaction(t_options);
should that be t_behaviour =
FWIW there seems to be a related question in the .net list.
Jiri confirmed that the default is NoWait. This makes my
misunderstanding of the term deadlock complete, because in NoWait I
usually get an exception right off, which is all but a deadlock in the
way I used to understand it.
thanks, Helen.
The minimum abbreviation for the -password switch is -pass (not
-pas). This error is occurring because of confusion with -pa[ge_size].
I will try this ASAP. However, the help on gbak.exe should then be
updated. It reads -PAS(SWORD) Firebird password. (gbak.exe -? on
Somewhere along this:
FbTransactionBehavior t_behaviour;
FbTransactionOptions t_options;
t_behaviour = FbTransactionBehavior.NoWait;
t_options.TransactionBehavior = t_behaviour;
FbConnection conn = new FbConnection();
conn.BeginTransaction(t_options);
have fun!
André
Thanks for
Hi Gang,
preparing finally for the leap of faith and switch from 1.5.6 to 2.5.2
on all applications and databases. So far everything is still nice. I
followed documentations and postings on the -Fix_FSS_M switch.
I never made too wide use of UDFs, so I don't expect too many problems
there.
No I
choice for you is to test it by yourself.
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49
This is just a simplified example. There are multiple input
parameters and the where clause will get more complex. Do I have to
live with having the stored procedure check every record in my example?
First,
check if what you want to do can be done by other means, supposedly by
changing the
(top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
of the details
are quite limited. I am also a regular voter, but quite often I don't
understand politicians ;-)
At 01:40 AM 13/10/2012, André Knappstein wrote:
I am posting this *here* for 2 reasons:
1. obviously I got myself out of the membership of the ODBC
devel list somehow
No, you tried
, but which maybe is missing on a new Win-8 station:
VC++ runtimes are installed:
- 2005 (x86)
- 2008 (x86 and x64)
- 2008 SP1 (x86 and x64)
- 2010 (x86 and x64)
Thanks!
André
~~
mit freundlichen Grüßen,
André Knappstein
EDV und
71 matches
Mail list logo