On Tue, Sep 09, 2025 at 08:41:02PM -0400, Justin wrote:
> The author brings up threaded vs multi-process. That's an old old old old
> old conversation that has been shown there is no clear better way.
This is relevant to the next part:
> Number of open connections. so firebird can do 1000 open
On Wed, Sep 10, 2025 at 6:20 PM Justin wrote:
> On Wed, Sep 10, 2025 at 5:28 PM Nico Williams
> wrote:
>
>> [snip]
> I would really like out-of-band hints. These would be hints not
>> specified in the SQL itself but to be sent separately and which address
>> table sources or joins by name, li
On Wed, Sep 10, 2025 at 06:20:18PM -0400, Justin wrote:
> I am not following you here, Databases are going to be bound somewhere at
> some point, Disk,IO, Network IO, Memory, or CPU bound. Which one is
> causing the bottle neck just depends on the workload and size of the
> database.
>
> The nu
On Wed, Sep 10, 2025 at 5:28 PM Nico Williams wrote:
> On Tue, Sep 09, 2025 at 08:41:02PM -0400, Justin wrote:
> > The author brings up threaded vs multi-process. That's an old old old old
> > old conversation that has been shown there is no clear better way.
>
> This is relevant to the next part
On Tue, Sep 9, 2025 at 8:41 PM Justin wrote:
[snip]
> Multiple transactions per connection. I am asking WHY is that a feature.
> when one can have multiple sessions, what is the difference? running
> multiple transactions in single or multiple sessions means moving part of
> transaction logic
On 2025-Sep-10, Justin wrote:
> On Wed, Sep 10, 2025 at 3:41 AM Ellen Allhatatlan <
> [email protected]> wrote:
> > > The author brings up threaded vs multi-process. That's an old old old
> > old old conversation that has been shown there is no clear better way.
> >
> > This is where thi
On Wed, Sep 10, 2025 at 3:41 AM Ellen Allhatatlan <
[email protected]> wrote:
> Hi, and thanks for your input,
>
> Just before I reply - if you (at least here in Ireland - Google's
> answers vary per location, unlike Duckduckgo's) search for "firebird
> mvcc mechanism" the "AI assistant"
> Though I would like to know what happened in mid 2010?:
> https://github.com/FirebirdSQL/firebird/graphs/contributors
Yes, indeed, WTF? I'm not a member of the FB Illuminati - so I can't say!
> > OK again. I'm just wondering if the single file per database isn't a
> > fundamental architectural
Hi, and thanks for your input,
Just before I reply - if you (at least here in Ireland - Google's
answers vary per location, unlike Duckduckgo's) search for "firebird
mvcc mechanism" the "AI assistant" tells me twice that FB's MVCC
implementation is "like PostgreSQL's"... I'll investigate further a
