Karol...
My misunderstanding I should apologize to you...
I misunderstood you when you said, "Firebird cannot use composite index
here"...
I thought you may have been trying to suggest them to the person who opened
the thread but couldn't with the way his SQL query had been
15.11.2019 22:09, jerz...@o2.pl [firebird-support] wrote:
> But only for FB 2.5, not for FB3!
> My question was about FB3. Where is info about new versions?
In Release Notes for these versions.
Maximum size of record was not changed.
--
WBR, SD.
Regards,Karol Bieniaszewski
>>However, I am not sure why Karol suggested the construct of composite
>>indicies in his replyI have suggested opposite "Create separate indexes",
>>maybe my English construction was not good.Regards,Karol Bieniaszewski
But only for FB 2.5, not for FB3!
My question was about FB3. Where is info about new versions?
> This is very useful info!!!
On Fri, Nov 15, 2019 at 5:13 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
>> What is
This is very useful info!!!
On Fri, Nov 15, 2019 at 5:13 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
> > What is the max record size in FB3 (in bytes)?
> > I search for this information without success.
>
>
15.11.2019 10:56, fbianch...@yahoo.com [firebird-support] wrote:
> any hint?
https://groups.google.com/forum/#!forumsearch/firebird-net-provider;context-place=overview
--
WBR, SD.
15.11.2019 12:56, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support]
wrote:
> Does any database/standard have such mechanism in DB-Engine level that
> application could
> get some kind of notifications of updates.
Firebird has events (read Language Reference about POST_EVENT), Oracle
I'm getting the error message Unrecognized Service Parameter Block during
FbBackup.Execute in my c# code.
I'm using code found in the FireBird online documentation.
myConnectionString =
"User=SYSDBA;" +
"Password=masterkey;" +
I've been pondering that is quite common to have static or very close to static
tables (and for sure that don't update that often). If you don't have some kind
of application server that can notice such an update (From app side). You have
not much better choice to just poll the changes/refresh
I was going the recommend the same join constructs as Karol did.
However, I am not sure why Karol suggested the construct of composite indicies
in his reply as I thought you were going to create 2 additional indices, one
for each of the fields in the multiple or clauses. As a result, this
Hi
Your problem is that you have (X or X) and (Y or Y)
Firebird cannot use composite index here.
Maybe it can somehow make something like (X1 and Y1) or (X1 and Y2) or … or (X1
and YN) or (X2 and Y1) or (X2 and Y2) …. (XN and YN)
But it will be never optimal.
Create separate indexes for magasin
Hi,
I'm on Windows 7, running Firebird 3.0.4 :
I have this table hosting 1475813 records :
CREATE TABLE JOURNAL_CAISSE (
UID UNIQUEID NOT NULL /* UNIQUEID = CHAR(16) */,
NUMERO INTEGER NOT NULL,
TYPE_MOUVEMENT INTEGER NOT NULL,
DATEHEURE TIMESTAMP
> If I try embedding, I always have the error
> "operating system directive access failed -Not a folder"
For info, embed works very well under the user "root" (no error
message).
under any other user, even having "root" rights it does not pass.
--
Norbert Saint Georges
http://tetrasys.fi
15.11.2019 12:45, 'Harald Wolf' firebir...@online.de [firebird-support] wrote:
> Any suggestions?
Dig into IBPP sources and find out the reason.
Use debugger.
--
WBR, SD.
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
> What is the max record size in FB3 (in bytes)?
> I search for this information without success.
https://firebirdsql.org/en/firebird-technical-specifications/
--
WBR, SD.
>> Does each record consume a page, or are could there be multiple records on a
>> page?
>Multiple records can be on one data page or one record can be split to
> several database
> pages depending on record's size.
What is the max record size in FB3 (in bytes)?
I search for this
17 matches
Mail list logo