Hi.

We found some minor performance on some querys in fb 1.5.1 compared to
1.5.

Here is one example:
This Query:

SELECT DISTINCT EXP.ID,EXP.NIVELORIGEN,EXP_REG.FECHAASIENTO,EXP_CADE.
FVENCIMIENTO,
NOTAR.NOMBRE STNOTARIOS, REG.NOMBRE STREGISTRO,
POBL.ID, POBL.ZONA1
, DOC.DESCRIPCION STDOCUMENTO, EXP_CADE.PROTOCOLO, EXP_CADE.ANYO,
EXP_CADE.FDOCUMENTO
FROM EXP_REGISTROS EXP_REG
LEFT JOIN EXP_CADEGEST EXP_CADE ON EXP_REG.EXPEDIENTE = EXP_CADE.
EXPEDIENTE
LEFT JOIN EXPEDIENTES EXP ON EXP_REG.EXPEDIENTE = EXP.ID
LEFT JOIN PROVI_DOCUMENTOS DOC ON EXP_CADE.CONCEPTO = DOC.CODIGO
LEFT JOIN NOTARIOS NOTAR ON EXP_CADE.NOTARIO = NOTAR.ID
LEFT JOIN REGISTROS REG ON EXP_REG.REGISTRO = REG.ID
LEFT JOIN POBLACION POBL ON REG.POBLACION = POBL.ID
WHERE ASIENTO IS NULL
AND EXP_REG.FECHAASIENTO IS NOT NULL
AND (DOC.EXCEMPTO = 0 OR DOC.EXCEMPTO IS NULL) AND (DOC.NOSUJETO = 0
OR DOC.NOSUJETO IS NULL)
AND EXP_CADE.FDOCUMENTO IS NOT NULL

has an performance analisis if FB 1.5 of:
Prepare : 31
Execute : 234
Avg fetch time: 234,00 ms

and on a FB 1.5.1:
Prepare : 188
Execute : 4.500
Avg fetch time: 4.500,00 ms


We try it in diferent machines and OS, RH 8.0 and win2000. First with
fb
1.5 and then with fb 1.5.1 and some times the difference is from 10
seconds in 1.5 and 25 in 1.5.1. With all the tests we do a backup and
restore, and we are the only user on the fb server.
Do anyone found something similar?

Thanks in advance.