Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Alex Peshkoff via Firebird-devel
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

Re: [Firebird-devel] FB4 fetches

2017-09-19 Thread Alex Peshkoff via Firebird-devel
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

[Firebird-devel] [FB-Tracker] Created: (CORE-5617) Limit for Event table size

2017-09-19 Thread Pavel Cisar (JIRA)
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

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Magnus Johansson
> -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

Re: [Firebird-devel] FB4 fetches

2017-09-19 Thread livius
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