Hi Cisar Type 30 is a dynamic file, so it should be looking after itself pretty well. I believe there are time one of these needs resizing, but as I have none here, I cannot tell you how/where/when
200,000 records is not really very much. I have some with 2,000,000. What WOULD help you enormously is if you build an index on that file for the ETIQUETTA column... eg > CREATE.INDEX GCMLIPE ETIQUETTA > BUILD.INDEX GCMLIPE ETIQUETTA DET.SUP Your next select should fly... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera Sent: 25 June 2004 10:42 To: [EMAIL PROTECTED] Subject: [U2] Performancing of File Universe Hello, I'm have 2 files with 200000 records, and when I execute one command "SELECT ETIQUETA FROM GCMLIPE WHERE ETIQUETA <> 0;" is very slow, it take about 10 seconds. Can anybody help me to performance of the files. In this moment the type of files is 30 and the number of records is 200000. Thanks. Cisar Riba Cervera (Spain) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004 ------- 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/
