600,000 records will do that. You might try exporting it as a MS Access Database, or even better, a .dbf file. This will nix the geography. If not, try upgrading to a higher speed SCSI hard drive (if you perform such queries regularly.)
Hope this helps, Ryan Morgan Aerials Express www.Aerials-Express.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 7:46 AM To: [email protected] Subject: MI-L Problem saving results I have run a successful Mapinfo SQL query which generates a table with approximately 600,000 records. There are two tables, a 1km grid and a set of irregular polygons which represent soil types. The query runs quickly enough but when I attempt to save the results, it is amazingly slow. It had done less than 10% in the morning having asked it to save at about 3pm the previous day. I am not interested in the 'objects' just the data (it includes an areaoverlap function). Basically I am trying to determine what is the amount of each soil type is in each grid square. The filesizes in the resulting (10% complete ) mapinfo files were not scary, 6-7mb max so there must be something else going on. Has anybody got any ideas? Thanks andy Disclosure of Material Facts Every Proposer or Insured / Reinsured when seeking new insurance / reinsurance or renewing an existing Policy must disclose any information which might influence the Insurer / Reinsurer in deciding whether or not to accept the risk, what the terms should be, or what premiums to charge. Failure to do so may render the insurance / reinsurance voidable from inception and enable the Insurer / Reinsurer to repudiate liability. This email, together with any attachments, is for the exclusive and confidential use of the addressee(s) and may contain legally privileged information. Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. While attachments are virus checked, Aon Limited does not accept any liability in respect of any virus which is not detected. Aon Limited Company Number: 210725 Registered Address: 8 Devonshire Square, London, EC2M 4PL Aon Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15512 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15545
