I believe I've possibly found a strange bug. Look at this query:

SELECT
P.ID_PESSOA,
F.NR_FONE
FROM
PESSOA P
INNER JOIN FONE F
ON (F.ID_PESSOA = P.ID_PESSOA AND
F.NR_FONE NOT IN
(SELECT
SKIP 1 FF.NR_FONE
FROM FONE FF
WHERE
FF.ID_PESSOA = P.ID_PESSOA))

This way, I want all persons and ONLY ONE phone number among the phones
related to that person (in this case, the first one).

As a result, Firebird simply ignores SELECT FIRST/SKIP in subqueries
(noticed in all tests I've performed). If I change, for instance, the
SKIP 1 FF.NR_FONE to MAX(FF.NR_FONE) the subquery is correctly
evaluated.

Shall I report this to the bug list on sourceforge (just in case it's
really a bug, of course)?

Any clue/comments?

[]'s

Fernando Deola
EFEX Systems Ltda.
Blumenau - SC - Brasil

-----Mensagem original-----
De: Gerhard Knapp [mailto:prometheus@...]
Enviada em: sexta-feira, 30 de agosto de 2002 17:21
Para: ib-support@yahoogroups.com
Assunto: [ib-support] Slow connection - PROBLEM IS SOLVED, HURRA

at first, thank you all for you nice help and very good tipps!



now, its unbelivable....

i have optimized p.e. windowsXP prof., and set in controlpanel, system,
performance-options,

(sorry i have the german version), optimal performance for
processplaning to
BACKGROUNDProcesses.

You have the choice: Programms or Backgroundprocesses



My thinking was: Firebird is running as a SERVICE and started with
SYSTEM,
and is a backgroundprocess!



But as i changed this to: Programms, the slow connection was gone
!!!!!!!



NEVER SET THIS PERFORMANCE OPTION TO BACKGROUNDPROCESS!



Now i have a connection-time between 1-2 seconds, and this is very okay
...

Before it was 7 till 16 seconds



best regards

-gerhard

[Non-text portions of this message have been removed]



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/