On 2019-11-14 23:47, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Doesn't the page size definition as per a database depend on one
> designs their database tables and how such tables will be used?
The page size doesn't restrict or limit your database design, with the
exception of
On 2019-11-15 00:12, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> Thanks for clarifying! This is very useful info, especially the
> ibexpert.net [1] site.
>
> Is there a Firebird site that provides details such as CHAR and
> VARCHAR max sizes, pageSize size options, etc.?
Most
Thanks for clarifying! This is very useful info, especially the
ibexpert.net site.
Is there a Firebird site that provides details such as CHAR and VARCHAR max
sizes, pageSize size options, etc.?
```
On Thu, Nov 14, 2019 at 5:07 PM Dimitry Sibiryakov s...@ibphoenix.com
14.11.2019 23:47, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Doesn't the page size definition as per a database depend on one designs
> their database
> tables and how such tables will be used?
Cases when pages of smaller size have a speed advantage are very special and
Doesn't the page size definition as per a database depend on one designs their
database tables and how such tables will be used?
In any event, here is what the Developer Guide for version 3.0 of Firebird
states...
The actively supported versions of Firebird support the following page
14.11.2019 23:30, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> What is the max page size for Firebird 3?
16 kilobytes.
> Also, could you clarify a page?
Quoting
14.11.2019 23:19, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> The previous comments indicate that Firebird is Litle Endian.
It doesn't matter because Firebird client deliver length of VARCHAR in
native endiannes
and for the rest there are API functions to convert
What is the max page size for Firebird 3?
Also, could you clarify a page? Does each record consume a page, or are
could there be multiple records on a page?
`
On Thu, Nov 14, 2019 at 8:09 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 14.11.2019 13:41,
For a minor clarification. In the electronics world, we specify the
sequence of multiple bytes with the word "Endian".
Assume the hex number is 0x1A2B. For Big Endian, the 0x1A is first. For
Little Endian, the 0x2B is first. The previous comments indicate that
Firebird is Litle Endian.
(For
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> And that part of the documentation is unfortunately wrong (although I'm
> not sure why the language reference even cares to describe such an
> implementation detail).
This documentation is actively corrected and
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> Actually Dimitry, Steve was quoting from the Firebird 2.5 Language
> Reference:
>
On 14-11-2019 19:02, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 14.11.2019 18:01, blackfalconsoftw...@outlook.com [firebird-support] wrote:
>> However, the PDF language manual I have for version 2.5 does in fact state
>> the following...
>>
>>
>> "A fixed-length character
On 14-11-2019 18:01, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I found what we have been arguing over in the Firebird 2.5 Language
> Reference Manual since I don't seem to have the one for version 3.0. I
> looked for it at the Firebird site but it does not appear to be
On 14-11-2019 17:06, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> What do you mean I am wrong? I have merely re-iterated how all database
> engines I have worked operate.
Telling us how other engines work is not very relevant when discussing
Firebird, and when the **internal
Good evening,
I'm blocking on a series of problems that you certainly have the
solution for.
When I change the value IPv6V6Only "0 | 1" "False | True" I have a
socket error in Firebird.log and no way to connect.
If I try embedding, I always have the error
"operating system directive access
Excellent!
A big thank you for your work
>
> I put a backup of the database (Firebird 3) on
> https://www.dropbox.com/s/ep17q5hv43iwkll/fb_reserverwords_20191112.7z?dl=0
>
> This represents the state of 7 months ago, so it might not contain
> keywords introduced in 2.5.9 and recent Firebird 4
14.11.2019 18:01, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, the PDF language manual I have for version 2.5 does in fact state
> the following...
>
>
> "A fixed-length character data type. When its data is displayed, trailing
> spaces are added
> to the string up to
I found what we have been arguing over in the Firebird 2.5 Language Reference
Manual since I don't seem to have the one for version 3.0. I looked for it at
the Firebird site but it does not appear to be listed...
>>>
CHAR DATA TYPE (CHAR(n), CHARACTER(n))
On 2019-11-14 03:40, Richard Damon rich...@damon-family.org
[firebird-support] wrote:
> 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
On 2019-11-13 17:37, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
14.11.2019 17:08, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> The links provided to me had the information on the IB-Experts web site...
I didn't see who provided you any link, but here is right one:
https://firebirdsql.org/en/reference-manuals/
At the bottom of this page
14.11.2019 17:06, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> What do you mean I am wrong? I have merely re-iterated how all database
> engines I have
> worked operate.
How "all database engines operate" is irrelevant here. You are wrong in your
assumption
how Firebird
The links provided to me had the information on the IB-Experts web site...
If there information is incorrect, you should contact them to have it
corrected...
Steve Naidamast
Sr. Software Engineer
What do you mean I am wrong? I have merely re-iterated how all database
engines I have worked operate.
And what you are saying is that a CHAR field in Firebird acts in the same
manner as that of a VARCHAR field. If that were the case there would be no
difference in how they are used and
< INSERT INTO LOG(WAS) VALUES ('blabla');
causes the error:
Statement failed, SQLSTATE = 23000
validation error for column "LOG"."ID", value "*** null ***"
if postet with the c++ code:
IBPP::Transaction _tr = IBPP::TransactionFactory(db);
IBPP::Statement st =
14.11.2019 15:06, 'Harald Wolf' firebir...@online.de [firebird-support] wrote:
> i use the ibpp.org c++ lib. How can i get the firebird sql error in my c++
> code?
This is a Firebird support list. Your question belongs to IBPP support.
--
WBR, SD.
14.11.2019 13:41, 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?
Optimum page size doesn't depend on data but on application usage.
I can repeat once again:
On 2019-11-13 15:51, 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
On 2019-11-13 18:42, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
>
Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
CHARACTER SET UTF8" --- what is the optimum pageSize?
14.11.2019 12:43, kragh.tho...@yahoo.com [firebird-support] wrote:
> Just to be sure, /tmp should be mounted with tmpfs, like in this archicle?
Yes and add some automatic swap management like here:
https://unix.stackexchange.com/questions/134258/dynamically-growing-swap-file-on-debian
--
Hey Dimitry Thanks for the answer. Just to be sure, /tmp should be mounted with
tmpfs, like in this archicle?
https://linoxide.com/file-system/use-tmpfs-rhel-centos-7-0/
https://linoxide.com/file-system/use-tmpfs-rhel-centos-7-0/
14.11.2019 03:40, Richard Damon rich...@damon-family.org [firebird-support]
wrote:
> By the SQL standard, there are some noticeable effects. CHAR is defined
> as a fixed width, so data is padded with blanks to reach that width, and
> then the blanks are removed on retrieval.
>
> Firebird might
34 matches
Mail list logo
