On 29-5-2015 16:10, Maxim Smyatkin wrote:
> Hello,
> Recently we've got an information from some company that they would like
> to use Firebird/Red Database with OpenCMS, but they couldn't afford it
> because of bad performance. We compared it with PostgreSQL and it was
> true - on some page views
Yes, that's right. Commit_retaining doesn't release acquired resources and
it shouldn't. But I still believe it's a bug in the Firebird itself,
because procedure after creation should decrement relation use count, but
it doesn't. Any of the steam blob tests fail even when executed separetely.
Surel
To better understand the implications of the pull request by Maxim, I'd
like to know the semantics of isc_tpb_autocommit. Is this documented
anywhere?
I'd especially like to know at which point the commit is executed, and
the impact this has on open resources (cursor, blob, etc). As far as I
u
On 30-5-2015 10:21, Maxim Smyatkin wrote:
> Surely I would like to see the same optimization in Jaybird 3, but I'm
> currently more interested in 2.2.*.
I understand and it will end up in 2.2, just not in 2.2.8 ;). This
change has some implications that I need to understand better before I
can r
I just tried to download
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/Firebird-3.0.0.31845-0_x64.7z
and the archive is only 3 MB (previous snapshot I downloaded was 7 MB).
Unpacking gives an error that archive is corrupted.
Another curious thing is that
http://web.firebirdsql.o
Oh, and it worth mentioning - I tried it only with latest FB 2.5
On Sat, May 30, 2015 at 11:33 AM, Mark Rotteveel
wrote:
> On 30-5-2015 10:21, Maxim Smyatkin wrote:
> > Surely I would like to see the same optimization in Jaybird 3, but I'm
> > currently more interested in 2.2.*.
>
> I understand
On 30-5-2015 10:29, Mark Rotteveel wrote:
> To better understand the implications of the pull request by Maxim, I'd
> like to know the semantics of isc_tpb_autocommit. Is this documented
> anywhere?
>
> I'd especially like to know at which point the commit is executed, and
> the impact this has on
[
http://tracker.firebirdsql.org/browse/CORE-4740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Zotov reopened CORE-4740:
---
Ticket should be reopened. Following query:
===
with
d(txt,ptn) as(
select
'aggagg', '(a{1}gg){2}'
Get "Different logins in connect and attach packets - client library error"
when DENY to create database using valid pair login+password of user who was
granted this privilege
30.05.2015 11:53, Mark Rotteveel wrote:
> I'd also like to know when isc_tpb_autocommit was introduced.
Somewhen before Firebird was created.
Dmitry
--
Firebird-Devel mailing list, web interface at
https://lists.sour
30.05.2015 11:29, Mark Rotteveel wrote:
> To better understand the implications of the pull request by Maxim, I'd
> like to know the semantics of isc_tpb_autocommit. Is this documented
> anywhere?
I'm not aware of any place.
> I'd especially like to know at which point the commit is executed, an
30.05.2015 11:42, Mark Rotteveel wrote:
> I just tried to download
> http://web.firebirdsql.org/download/snapshot_builds/win/3.0/Firebird-3.0.0.31845-0_x64.7z
> and the archive is only 3 MB (previous snapshot I downloaded was 7 MB).
> Unpacking gives an error that archive is corrupted.
>
> Another
30.05.2015 11:29, Mark Rotteveel wrote:
> To better understand the implications of the pull request by Maxim, I'd
> like to know the semantics of isc_tpb_autocommit. Is this documented
> anywhere?
AFAIR, no
> I'd especially like to know at which point the commit is executed, and
> the impact t
29.05.2015 17:10, Maxim Smyatkin wrote:
> 2. Whole TestFBBlobStream family (6 tests) fails. The reason is bug in
> Firebird transaction engine. When transaction started in
> auto-commit mode actually commits (via commit_retaining) it doesn't free any
> resources. E.g., what happens in these test
29.05.2015 17:10, Maxim Smyatkin wrote:
>
> - we create a procedure P using a table T.
> - the P states its interest in the T (while looking for P's dependencies);
> - transaction commits the changes with retaining flag and forgets to say
> that it isn't interested in the T anymore;
Externally (fo
grant create database to ROLE doesn`t work: "no permission for CREATE access to
DATABASE ..."
-
Key: CORE-4821
URL: http://tracker.firebirdsql.org/browse/CORE-4821
Yes, it makes sence. I was wrong as the procedure still depends on the
table, so it's the intented behaviour. But what I still can't understand is
why did it work before? I mean, old tests were using Jaybird's
AutoCommitTransaction which is just a wrapper around Manageable
transaction, so it should
17 matches
Mail list logo
