nageswaragunupudi wrote:FranciscoA wrote:What do you think about the 1000 records specified?
1000 seems large. But let us give it a try.
Please also let me know if the `codicont` field is numeric or character and what is the size of the field.
"CODICONT VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'Codigo Contable'," +;Not sure.
Can you still try and see?
SELECT A.codicont AS codigo, A.nombre AS nombre, B.codicont AS catalogo
FROM facturas A LEFT JOIN catalogo B
ON A.codicont = B.codicont ;SELECT * FROM
(
SELECT A.codicont AS codigo, A.nombre AS nombre, B.codicont AS catalogo
FROM facturas A LEFT JOIN catalogo B
ON A.codicont = B.codicont ;
) AB
WHERE catalogo IS NULLLet me make some changes. I'll back
nageswaragunupudi wrote:You said this takes only 3 seconds
SELECT A.codicont AS codigo, A.nombre AS nombre, B.codicont AS catalogo FROM facturas A LEFT JOIN catalogo B ON A.codicont = B.codicont ;
If so, you may try this
SELECT * FROM ( SELECT A.codicont AS codigo, A.nombre AS nombre, B.codicont AS catalogo FROM facturas A LEFT JOIN catalogo B ON A.codicont = B.codicont ; ) AB WHERE catalogo IS NULL
Please try both approaches
The demo server is now taking 1.56 to deliver the result.
FranciscoA wrote:The demo server is now taking 1.56 to deliver the result.
nageswaragunupudi wrote:FranciscoA wrote:The demo server is now taking 1.56 to deliver the result.
Are you referring to the FWH demo server? Now it took 90 seconds for me.
From your country it may be slower.
But how are you connecting the FWH demo server?
Are you using 1709 or 1204?
1709
Please try this approach on your tables and see.
The resulting string of 1000 records exceeds the maximum length for the Group_Concat () function.
I will continue investigating to see if I manage to overcome the 3 seconds that I have achieved so far.
Many thanks for your support.
Hola Francisco...
En principio no tengo intención de hacer HDO para xHarbour.
Ok.
Gracias Manu.
DROP TABLE IF EXISTS pruebas ;
CREATE TABLE pruebas
SELECT * FROM facturas GROUP BY codicont ;
SELECT fechemis,td,numdoc,codicont,nombre FROM pruebas
WHERE codicont NOT IN (SELECT codicont FROM catalogo WHERE nv = 'S') ;