Hello,
it's normal that only the indexes on one table is used during an inner
join ?
for exemple :
table a
ID = pk_index
DATE = index a_date = selectivity : 0.1
NAME = index a_name selectivity :0.1
table b :
REFIDA = fk_index
REFPRODUIT = index b_produit = selectivity : 0.2
NAME = index
= 0.0024333
B_IDX1 = 0.999
B_IDX2 = 0.999
B_IDX3 = 0.5
B_IDX4 = 0.999
Le 13/08/2012 18:54, Dmitry Yemanov a écrit :
13.08.2012 19:15, arnaud le roy wrote:
it's normal that only the indexes on one table is used during an inner
join ?
for exemple :
table a
ID = pk_index
DATE
and six millions lines and i obtain the same result.
Le 13/08/2012 19:55, Ann Harrison a écrit :
On Mon, Aug 13, 2012 at 11:15 AM, arnaud le roy sdnetw...@gmail.com
mailto:sdnetw...@gmail.com wrote:
it's normal that only the indexes on one table is used during an inner
join
Maybe this post found on necessitas could be usefull to port firebird
server to android :
--
Hello everyone,
We've faced some big problems which prevent us to release alpha4 SDK,
so, I think we own you some explanations why we delay it that much.
First problem we've encountered it
Maybe this post found on necessitas could be usefull to port firebird
server to android :
--
Hello everyone,
We've faced some big problems which prevent us to release alpha4 SDK,
so, I think we own you some explanations why we delay it that much.
First problem we've encountered it
Hello,
i have a strange thing with a superver 2.5.2 on windows.
when i do a request on a table and after ask for db stat the Oldest
transaction counter don't up i'm sure that the transcation is no longer
here because
1) select count(1) from mon$transactions = 0.
2) and i don't have any
:46, Alex Peshkoff a écrit :
On 03/01/15 15:44, arnaud le roy wrote:
Hi,
somebody can tell me what is the difference between
isc_spb_prp_shutdown_db
It's a command telling firebird that database must be shutdown.
and
isc_spb_prp_force_shutdown
This is the type of shutdown (one
:46, Alex Peshkoff a écrit :
On 03/01/15 15:44, arnaud le roy wrote:
Hi,
somebody can tell me what is the difference between
isc_spb_prp_shutdown_db
It's a command telling firebird that database must be shutdown.
and
isc_spb_prp_force_shutdown
This is the type of shutdown (one
> Le 9 avr. 2018 à 19:35, Alex Peshkoff via Firebird-devel
> <firebird-devel@lists.sourceforge.net> a écrit :
>
> On 04/09/18 15:55, Arnaud Le-roy wrote:
>> Hi,
>>
>> I contribute to node-firebird provider and I have question about the way to
>>
Hi,
I contribute to node-firebird provider and I have question about the way to
retrieve blob.
First it works well, but I think the way is not good and could cause future
problems (hang connection).
An exemple a request retrieve 2000 rows with two blob columns :
Today in the node provider,
> Also I do not see any thread actively working with database, i.e. probably
> one with AV (thread 2) is such thread. And in that case problematic UDF (as
> always) is first candidate to raise problems. Can one confirm that w/o UDF
> bug does not happen?
>
Yes w/o UDF the bug does not
>> char *uuid1maccompr()
>
> I wonder how this UDF is declared in the database…
>
DECLARE EXTERNAL FUNCTION F_UUID1MACCOMPR
RETURNS CSTRING(22) FREE_IT
ENTRY_POINT 'uuid1maccompr' MODULE_NAME 'FreeAdhocUDF’;
I have try w/o FREE_IT same behavior
Firebird-Devel mailing list, web interface
> Read, but telling true did not pay enough attention to it.
> Can you provide full build process of UDF? (compiler command line, etc., may
> be build screen log). May be something wrong with switches…
java@debian:~/crash$ cat uuid_functions.h
char * uuid1maccompr();
java@debian:~/crash$
13 matches
Mail list logo