Sorry, that didn't help... Thanks anyway Bjvrn Eklund
-----Ursprungligt meddelande----- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Perry Taylor Skickat: den 10 februari 2006 15:07 Till: [email protected] Dmne: RE: [U2] [u2][ud] Poor select performance My experience is with UniVerse but I suspect it would suffer from the same thing. It's likely the problem is the high number of records per customer number. You might try indexing the entire key then doing a select on the customer number portion. Something like this maybe (not sure of the UniData syntax) ... CREATE.INDEX A_FILE @ID BUILD.INDEX A_FILE @ID SELECT A_FILE WITH @ID LIKE 66-... OR SELECT A_FILE WITH @ID MATCHING "'66-'1N0N" Perry Taylor www.zirmed.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 10, 2006 6:09 AM To: [email protected] Subject: [U2] [u2][ud] Poor select performance Hi there, we are having very slow respone times on a select statement. We have a file with a total of 5 million records in where the key is like nnnn-nnnnnn. The first part(nnnn) is a customer number(numeric) and the second part(nnnnnn) is a sequential no. We have created an i-descriptor on the customer number, FIELD(@ID,'-',1). On this i-descriptor we have put an index: Index-Name...... F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr.... FAKT.FINR V Num Yes Yes Yes Yes S FIELD(@ID,'-',1) Selecting a customer with 570 000 records can take 30 seconds. (example of statement SELECT A_FILE WITH FAKT.FINR = 66) Selecting other indexed values in the same file which gives me 5 records out of the 5 million is very very fast. I've tried to rebuild.index with no improvment in performance. The file doesen't show any sign of level 2 overflow. I am single user on a powerful Sun server with SAN disks. We are on Solaris 8 and Unidata 6.1.10. Shouldn't it be faster than this? Perhaps this is normal and we have to take another approach to get the data we need? Thanks in advance! Bjorn Eklund Faktab Finans AB ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
