On 09/18/17 23:39, Magnus Johansson wrote:
Hello,
I'm looking on FB 3.0 and doing some thinking comparing with FB 2.5.
In 2.5 there is an index on RDB$USERS.RDB$USER_NAME and that field is defined
as VARCHAR.
In 3.0 there is no index on SEC$USERS.SEC$USER_NAME and it is defined as CHAR.
Looki
On 09/18/17 19:37, liviuslivius wrote:
Hi,
i do not know if message reach the group,
or it was wrong place to ask about FB4?
I asked about fetches because on previous versions of FB this not
occure. Maybe not really. on FB3 fetches fluctuate by only 1. But
under FB4 it fluctuate by 14 or even
Limit for Event table size
--
Key: CORE-5617
URL: http://tracker.firebirdsql.org/browse/CORE-5617
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.8, 3.0.3, 4.0 Bet
> -Original Message-
> From: Alex Peshkoff via Firebird-devel [mailto:firebird-
> de...@lists.sourceforge.net]
> Sent: Tuesday, September 19, 2017 10:19 AM
>
> > I'm curious about why there is no index on SEC$USERS.SEC$USER_NAME (*)
>
> You are right - because it's virtual table.
Thanks
Karol, I just can confirm that message reached the group. But right now
have no time to deal with fetches problem, sorry.
Thank you for response,
i understand that not all requests can be processed and analyzed immediately
and such answer that team is busy is enough
regards,
Karol Bieniaszews