Hi Set and Helen,

Thank you for answering. The case is I have just one week testing
Firebird, and trying to make our large application compatible with
it. Our proyect is tested with Oracle (100%) and PostgreSQL (80%),
and now we started testing Firebird one week ago and we can see all
our tables are running very well using it.

Problems comes when we start trying our full database query system,
in where users can choice a lot of filters, alone or togheter, over
main an related tables. In that situation, I am sure we are not doing
exactly the best "select" for each situation, but we tested a very
big number of combinations with Oracle, an always he need no more
than 5 seconds for giving us the full response.

Doing just onew combination with Firebird 2.1, we found he needs 10
minutes the fires time, and 2 seconds if we repeat the same query
later. Thanks Helen, I noted my firs input comparing embeded vs.
superserver was wrong, just because I did my first test using
embeded, and then I used Superserver, inmediatly over the same
database.

I found the cache is alive even if I shut down the Firebird Server;
the only way I found to clear the previous query from cache is by
rebooting the machine. (BTW is there another way to clear it???).

I am verifing the performance running our query expresion with
FlameRobin. The first run need near 10 minutes; next tests runs
faster.

Next I will copy for you the report I get from FlameRobin. Table PROC
hast 18.286 records; table MOVI has 154093.

Starting transaction...
Preparing query: select "PROC"."PROC","PROC"."EXP1"
as "EXPE","PROC"."ACTO","PROC"."DEMA","PROC"."OBSE","TPRO"."DSCR"
as "D_TPRO" from "PROC" left outer join "TPRO"
on "PROC"."TPRO"="TPRO"."TPRO" where ((exists (select "PROC" from
(select "MOVI"."PROC" from "MOVI" where "MOVI"."TIPO" = 'B') T where
T."PROC" = "PROC"."PROC"))) order by lower("PROC"."ACTO")
Prepare time: 00:00:01.
Field #01: PROC.PROC Alias:PROC Type:STRING(10)
Field #02: PROC.EXP1 Alias:EXPE Type:STRING(18)
Field #03: PROC.ACTO Alias:ACTO Type:STRING(200)
Field #04: PROC.DEMA Alias:DEMA Type:STRING(200)
Field #05: PROC.OBSE Alias:OBSE Type:STRING(120)
Field #06: TPRO.DSCR Alias:D_TPRO Type:STRING(120)
PLAN (T MOVI INDEX (MOVI_PROC))
PLAN SORT (JOIN (PROC NATURAL, TPRO INDEX (TPRO_PK)))


Executing...
Done.
429914 fetches, 8 marks, 139758 reads, 8 writes.
0 inserts, 0 updates, 0 deletes, 151675 index, 33586 seq.
Delta memory: 49648 bytes.
Execute time: 00:09:39.

Please, let me know if you need more information. I can upload a copy
of the database if you want. (Empty: 600 kb)

Thank you very much.

Dany