Sorry, I don't want to annoy, but can I do this with a separate
list-function or is it possible to realize it with new functions in firebird
4?
TA TB
A B B is a part from A
A C C is a part from A
A D D is a part from A
D X X is a part from
Hi,
from your description i really do not know what is working for you and what is
not working.
And your expectation.
but to understand recursive CTE look at simple sample. Recursive CTE work
throught tree.
### metadata ###
CREATE TABLE TEST_T
Hey Alexey Thanks for the advise, I changed TempCacheLimit to 21, last
night and it looks like it had a positive effect on the disk queue size on sda.
I have read a lot about Firebird tuning however I have never come across that
limit on fb 2.5
https://pasteboard.co/IGsU650A.png http
Hello Thomas,
My advice was only to fix the obvious mistake regarding the TempCacheLimit.
In general, I don't see a problem in high traffic to /tmp, and I don't
understand why do you think sorting queries produce the problem - and
even if they produce, the first attempt would be to identify su
Hey Alexey Its not that I see high traffic to /tmp as a problem, I was just
worried that it was becoming a bottleneck in our system. Great to know that
HQbird has a way of tracking these qureys, I have already been looking into
HQbird especially because of prepared statements.
Regarding the
13.11.2019 11:59, kragh.tho...@yahoo.com [firebird-support] wrote:
> Its not that I see high traffic to /tmp as a problem, I was just worried that
> it was
> becoming a bottleneck in our system.
In this case you can use for it tempfs backed up with auto-expanded swap
files.
--
WBR, SD.
13.11.2019 01:14, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
wrote:
> I recently installed Firebird Client (2.5.8) and Firebird ODBC drivers
> (2.0.5) on a
> clients RDS server and was told I had broken a previously installed app that
> appears to
> use FB Embedded.
>
> The er
On 2019-11-12 23:06, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> As I understand, the FbConnection.CreateDatabase max pageSize for
> VARCHAR is 8191. Does the page size change to less than 8191 if the
> VARCHAR is less?
>
> What is the max pageSize for CHAR?
Page size is about
Hello Thomas,
Ok, good to know that you are prepared for the migration! FB3 with
proper migration and config certainly will increase the overall performance.
In my presentation regarding Linux I spoke about specific case which is
under everyday control, and in our long way, we also started wi
13.11.2019 12:41, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> we also started with Page Buffers = 25% RAM and increased it step by step
> (and still
> continue to work with fine tuning).
Isn't it better to use cache hit ratio to make the decision about its growth?
--
WB
Hey Alexey Thanks for the answer, I only have one question left, do I need to
adjust linux page cache(vm.pagecache) according to amount of RAM allocated for
DefaultDBCachePages, so that memory is not over "subscribed"? Eg. if
DefaultDBCachePages is increased should i then decrease vm.pagecache?
> On Nov 12, 2019, at 10:44 PM, Richard Damon rich...@damon-family.org
> [firebird-support] wrote:
>
>> On 11/12/19 12:38 PM, cte...@gmail.com [firebird-support] wrote:
>>
>>
>> What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR
>> consumes less space. Anything thing else (a
Hello,
Yes, better use default - pagecache in terms of Linux is different from
Page Buffers/Page cache of Firebird.
Regards,
Alexey
On 13.11.2019 15:10, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey Alexey
Thanks for the answer, I only have one question left, do I need to
adjust l
Hello,
For predictable load reads/fetches is very useful metric, but in case of
spikes like Thomas has - 96 connections to 1300, it will be far less useful.
Regards,
Alexey
On 13.11.2019 14:50, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.11.2019 12:41, Alexey Kovyazin
Thanks for the useful responses!
Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
CHARACTER SET UTF8" --- what is the optimum pageSize?
```
On Wed, Nov 13, 2019 at 6:17 AM Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
>
>
>
>
> > On N
13.11.2019 15:07, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
> CHARACTER SET
> UTF8" --- what is the optimum pageSize?
As big as possible for your Firebird version.
--
WBR, SD.
--
Thank you Anne, for your succinct comments regarding the differences between
the efficiencies of a CHAR and VARCHAR field definitions.
Human observation cannot actually elicit any observable effects between the
two.
However, internally, the CHAR field definition is more efficient as th
13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, internally, the CHAR field definition is more efficient as the
> database does not
> have to perform any field size calculations at the moment that data is being
> updated to a
> VARCHAR field.
No such ca
Hello Karol,
thank you, that was the one piece I was looking for, the right position for the
listing.
Best thanks.
Regards.
Olaf
Von: firebird-support@yahoogroups.com
Gesendet: Mittwoch, 13. November 2019 09:51
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-
Though I cannot dispute what you are saying, to me it does not make much sense.
If a VARCHAR field is defined for 1000 characters and it is stored in the
table at a 1000 character length than there is no purpose to an actual VARCHAR
field definition.
VARCHAR fields have always been dy
Whether I used a mapped drive letter, or a UNC path, if I try to restore a
backup from a network drive it fails, with a message like "Cannot open file".
I fully understand why Firebird won't open a database file on a network drive,
but I'm trying to do the restore to a DB on a local drive. An
13.11.2019 16:09, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> If a VARCHAR field is defined for 1000 characters and it is stored in the
> table at a 1000
> character length than there is no purpose to an actual VARCHAR field
> definition.
There is. I addition to 1000 characte
13.11.2019 16:45, dco...@sympatico.ca [firebird-support] wrote:
> Whether I used a mapped drive letter, or a UNC path, if I try to restore a
> backup from a
> network drive it fails, with a message like "Cannot open file".
Don't you by chance try it using Services API or "-se" switch of gbak?
> On Nov 13, 2019, at 10:01 AM, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
>
> 13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote:
>> However, internally, the CHAR field definition is more efficient as the
>> database does not
>> have to perform
Your statement, which may be true, does not sit well with a previous statement
that states that a VARCHAR field of 1000 characters is stored in the table with
1000 characters.
Your statement is suggesting a null length (until the field is updated) with
two bytes for an actual length, which i
13.11.2019 17:37, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Your statement is suggesting a null length (until the field is updated) with
> two bytes for
> an actual length, which is how VARCHAR fields work in all other databases to
> my
> knowledge. Otherwise, to follow the p
Here is the link to the definition of CHAR and VARCHAR field definitions from
the IB-Experts site...
https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR
https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR
It defines the storing of CHAR and VARCHAR in the same manner, though the
VARCHAR data
We're actually already doing the backups and restores with the Services API.
13.11.2019 18:53, dco...@sympatico.ca [firebird-support] wrote:
> We're actually already doing the backups and restores with the Services API.
Usually account used to run Firebird server has no access to network at all.
Thus the
error you see.
--
WBR, SD.
-
13.11.2019 18:42, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> So my understanding of how the VARCHAR field works is correct and what I have
> stated earlier.
Your understanding is wrong and either IB Expert site is wrong as well or
you misread it.
Yest remember: CHAR - for
Recently I ran a "Database statistics" with ibexpert on one of our dbs, and
there were a lot of tables marked in yellow, with the tooltip saying "Table
xxx Is fragmented"
I couldn't quite find an explanation for it online, so I have a few doubts
about it:
* Is this the same as index frag
I'm developing a new updater for my application that uses a Firebird database.
My old version was using the gbak tool for backup and restore the
database (in a secondary FDB). If the backup and restore was finishing
with success, I acsume that the database integrity is OK.
The problem is that thi
Hi all,
I have recently run into INET/inet_error: fork/CreateProcess errno = 5 error in
one of my Firebird boxes and I was wondering if anyone could help me with
understanding what it actually means.
I have several identical Windows Server machines running Firebird 2.1.3 64-bit
in Classic Serv
Hey Alexey First of all, thanks for all the help. Second, have you or anyone
else working professional with Firebird thought about writing a book about
Firebird optimisation - I would for sure buy a copy.
Hey Dimitry Just to clarify, one could make a RAM drive with tmpfs, eg
/ramdrive, and then specify this path in firebird.config under
"TempDirectories"?
If correctly understood, does this provide any benefits over just allocation
more memory for TempCacheLimit, under Firebird 3?
Thomas Kr
13.11.2019 21:06, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to clarify, one could make a RAM drive with tmpfs, eg /ramdrive, and
> then specify
> this path in firebird.config under "TempDirectories"?
Not quite.
> If correctly understood, does this provide any benefits over just
Thank you, that is the correct answer. When I tried with embedded Firebird,
that doesn't use the services manager, it works fine, with either way of
accessing the network drive (UNC path or mapped drive letter).
Feeling a bit dumb. :)
On 11/13/19 9:51 AM, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
>
> Thank you Anne, for your succinct comments regarding the differences
> between the efficiencies of a CHAR and VARCHAR field definitions.
>
> Human observation cannot actually elicit any observable effects
> between
+1
> Hey Alexey
> First of all, thanks for all the help. Second, have you or anyone else
> working professional with Firebird thought about writing a book about
> Firebird optimisation - I would for sure buy a copy.
>
>
>
39 matches
Mail list logo