Hello Chris, I'd bet my last pound that your data is from a grid or matrix - elevations or similar? If this is the case, consider using grids to store the data. Not only do queries fail with large record counts, but managing and visualising so much data will be slow and difficult.
Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: Chris Loty [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 3:57 AM To: Directionsmag. . . . . (E-mail) Subject: MI-L huge points file.... Good afternoon one and all, i have a points file with 16 million points. I would like to rip out half of them which have a null value of -9999. I have successfully opened the file in Access and Mapinfo but when i choose to remove the points in Mapinfo by doing a select on the null value it decides to "not respond". Do i have any other options ?? regards Chris Loty Wind Business Project Officer Sustainable Energy Development Authority (w) 9249 6192 (f) 9299 1519 http://www.seda.nsw.gov.au This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of SEDA. The sender cannot guarantee that this email or any attachment to it is free of computer viruses or other conditions which may damage or interfere with data, hardware or software with which it might be used. It is sent on the strict condition that the user carries out and relies on its own procedures for ensuring that its use will not interfere with the recipient's systems and the recipient assumes all risk of use and absolves the sender of all responsibility for any consequence of its use. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2247 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2266
