RE: [UV] Very slow SQL query
César, So the problem is not joins or indices. So it must be somewhere else :-) 1. If you use a SORT command, is that as slow? SORT CCMLIAL BY EMP BY ALBA BY NUMLIN WITH EMPABLA = "1*05236" PEDIDO REFART DESART CANDIDAD CANTMODALB NOPAGE 2. If it is, what are these fields doing? Are they Data fields or I Descriptors? Do any call BASIC subroutines, or do translates (TRANS or XLATE functions?) 3. The obvious one - what is the file sizing like? 4. What does the BASIC program do that is different? There should be no reason for this SQL command to be slow. Brian Leach > Hello, > > > I have two files one has 300.000 records and another has > 200.000 records, I wante to make SQL Query whit the two files > and this takes bettewn 30 seconds and 1 minute to return the result. > > However, I have a program with BASIC to obtime the same > result and it takes less than one second, I have heard that > other DB Systems like SQL Server, Oracle, etc... are very > fast with the SQL Query. > > Is this posible or do have I made a mistake? > > > Thanks > > > César > This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Very slow SQL query
Hello Björn I build the index and the result is equal. Tanks. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Björn Eklund Enviado el: jueves, 19 de febrero de 2004 17:41 Para: 'U2 Users Discussion List' Asunto: SV: [UV] Very slow SQL query Cesar, You need to build the index also, try BUILD.INDEX ALL In Unidata that is. Björn Eklund -Ursprungligt meddelande- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 17:24 Till: 'U2 Users Discussion List' Ämne: RE: [UV] Very slow SQL query -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Brian Leach Enviado el: jueves, 19 de febrero de 2004 16:22 Para: 'U2 Users Discussion List' Asunto: RE: [UV] Very slow SQL query César, I think we will need more information to help you. 1. are you running the SQL query at TCL or through ODBC or OleDB? César: I running the SQL query at TCL 2. Can you give the command you are running please. Cesar: SELECT PEDIDO,REFART,DESART,CANTIDAD,CANTMODALB FROM GCMLIAL WHERE EMPALBA = '1*05236' ORDER BY EMP, ALBA, NUMLIN; Cesar: SELECT PEDIDO, SUREF FROM GCMLIAL WHERE EMPALBA = '1*05236' GROUP BY PEDIDO, SUREF; 3. Are there any indexes on the files? (LIST.INDEX filename ALL) Cesar: There aren't indexes on the files, I create index but the result is the same. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 19 February 2004 15:04 To: [EMAIL PROTECTED] Subject: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Very slow SQL query
-Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Brian Leach Enviado el: jueves, 19 de febrero de 2004 16:22 Para: 'U2 Users Discussion List' Asunto: RE: [UV] Very slow SQL query César, I think we will need more information to help you. 1. are you running the SQL query at TCL or through ODBC or OleDB? César: I running the SQL query at TCL 2. Can you give the command you are running please. Cesar: SELECT PEDIDO,REFART,DESART,CANTIDAD,CANTMODALB FROM GCMLIAL WHERE EMPALBA = '1*05236' ORDER BY EMP, ALBA, NUMLIN; Cesar: SELECT PEDIDO, SUREF FROM GCMLIAL WHERE EMPALBA = '1*05236' GROUP BY PEDIDO, SUREF; 3. Are there any indexes on the files? (LIST.INDEX filename ALL) Cesar: There aren't indexes on the files, I create index but the result is the same. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 19 February 2004 15:04 To: [EMAIL PROTECTED] Subject: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Very slow SQL query
César, I think we will need more information to help you. 1. are you running the SQL query at TCL or through ODBC or OleDB? 2. Can you give the command you are running please. 3. Are there any indexes on the files? (LIST.INDEX filename ALL) Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 19 February 2004 15:04 To: [EMAIL PROTECTED] Subject: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users