Cesar, That is slow for such a small number of records. But if it is a type 30, I doubt that the file size is to blame.
What type of dictionary item is ETIQUETA? Is there an index on it? Brian On Fri, 25 Jun 2004 10:42:18 +0200 Cisar Riba Cervera <[EMAIL PROTECTED]> wrote: >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/ > >________________________________________________________________________ >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] To unsubscribe please visit http://listserver.u2ug.org/
