We frequently process tables with over 15 million records. We export to .dbf format, process in a dartabase and then return to MI and perform a PACK function for deletions.
John D. Haynes Director Geodata Consultants, Inc. 1-800-838-6661 ex.10 [EMAIL PROTECTED] www.geodataconsult.com ----- Original Message ----- From: "Denis Lalonde" <[EMAIL PROTECTED]> To: "Chris Loty" <[EMAIL PROTECTED]>; "Directionsmag. . . . . (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 10:23 AM Subject: Re: MI-L huge points file.... > Hello Chris, > > I've never tried queries on tables with 16 million > points, but I have done "more complexe queries" on > tables nearing 10 million and always come into the > same "MapInfo Not Responding"...but if I let it > run(usually for hours and sometimes overnight...) it > would eventually finish the query. > > So, MapInfo was doing my query even though it said Not > Responding.... = patience. > > Denis > > Denis Lalonde > DBx Geomatics > 37 St-Joseph Boul > Hull, QC > J8Y 3V8 > 819-772-2000 > [EMAIL PROTECTED] > www.dbxgeomatics.com > *********************** > try SVGMapMaker today! > *********************** > > --- Chris Loty <[EMAIL PROTECTED]> wrote: > > 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 > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 2255 > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2260