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 (are VARCHAR searches slower)?
>
In some implementations of SQL (I don't know if firebird is one of
them), a row
Hi everyone.
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 error is:
Attempting connection to localhost on port 30632
Failed to connect to
Hello Thomas,
Seems like your system generates a lot of sort files - the problem can
be that TempCacheLimit in Firebird 2.5 cannot be more than 2Gb -1.
When you set it to something between 2 and 4Gb, it means 0.
So, set something like
TempCacheLimit=21
Consider to tune other
12.11.2019 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?
Database page size has no relation with any data type
Hey
Where I work we run a website with at growing number of users, over a period
of two months we have seen Firebird slow down at peek hours, where the number
of concurrent website users is about 6.000. Usually there is about 250
attachments, however when the slowdown occurs the number rises
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?
On Tue, Nov 12, 2019 at 1:15 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]
On 12-11-2019 10:31, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 2019-11-12 10:14, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>> On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu
>> [firebird-support] wrote:
>>> Good morning all,
>>>
>>> Is
On 12-11-2019 13:37, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> Is this old bug from FB 2.5.x or some kind of feature ?
>
> This still exists in FB 3.x
It would be helpful to also describe the problem, and not only let
people execute a query and try to guess what
12.11.2019 18:38, cte...@gmail.com [firebird-support] wrote:
> I know that VARCHAR consumes less space.
It doesn't. CHAR has no advantages over VARCHAR in most usages. Only very
little cases
need fixed length data (and usually it is binary data).
--
WBR, SD.
What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR consumes less
space. Anything thing else (are VARCHAR searches slower)?
I just started getting these errors in Firebird.log. The first error is always
followed by the second. It appears to always be the same database. What might
be causing this? I am using Firebird 2.5.3.26778.
NOVADB (Server) Mon Nov 11 19:17:03 2019
Operating system call ReleaseSemaphore
This is not a bug, but a documented feature. list() returns BLOB. And blobs are
distict because BLOB_ID-s are compared.
SELECT DISTINCT, ORDER BY and GROUP BY work on the BLOB ID, not the contents.
https://firebirdsql.org/refdocs/langrefupd21-blob.html
Ist it possible somehow?
I would get each Part and the complete Path for it. If the Part is a
material, I would get it and the complete list with all parts from the first
til the material itself.
Thanks.
Hello,
I have the following situation:
There are some parts
Is this old bug from FB 2.5.x or some kind of feature ?
This still exists in FB 3.x
with cte as
(select 1 cnt from rdb$database
union all
select 2 from rdb$database
)
select list(cnt) from cte
union
select list(cnt) from cte
--
Regards,
Michał Kurczabiński
On 2019-11-12 10:14, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu
> [firebird-support] wrote:
>> Good morning all,
>>
>> Is there an exhaustive list of all the words reserved by version of
>> firebird (3.x, 4.x)
> Yes, it is in the doc folder:
> https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.keywords
I should have thought about it :-(
Thank you / Dankjewel
--
Norbert Saint Georges
http://tetrasys.fi
On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu
[firebird-support] wrote:
> Good morning all,
>
> Is there an exhaustive list of all the words reserved by version of
> firebird (3.x, 4.x) somewhere?
>
> Thank you in advance.
Yes, it is in the doc folder:
Good morning all,
Is there an exhaustive list of all the words reserved by version of
firebird (3.x, 4.x) somewhere?
Thank you in advance.
--
Norbert Saint Georges
http://tetrasys.fi
18 matches
Mail list logo
