David General point - index the column(s) you're performing the query on. This can have a dramatic effect. However the bad news is that MapBasic is not very quick with string comparison. If its still too slow then consider putting the data in something like Access and using a custom DLL function to call up a dialog in Access to return your x,y (or whatever).
This sounds like a pain and I suppose it is but the good thing is that it can be completely generic and reusable. A colleague once did this with a VB/MapX app and completely transformed the app performance (MapX isn't much better at strings) HTH Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Eagle, David A [mailto:[EMAIL PROTECTED] Sent: 02 June 2003 15:56 To: MapInfo-L ([EMAIL PROTECTED]) Subject: MI-L Query Efficiency Listers, I have created a gazetteer query tool (in MapBasic) to query an MI table containing 260,000 records. The process takes a variable from my dialog and searches the place name field (indexed) for instances LIKE it and then returns a query table containing two columns and the object. The process then goes on to populate an array etc, etc...However, the query process described takes 20 seconds, this is always the case and does not vary if I move the database from its network location to a local drive. Any thoughts on how I can speed this process up would be greatly appreciated... ---------------------------------------------- David A. Eagle GIS Consultant Atkins Design Environment & Engineering Cornerstone House Stafford Park 13, Telford Shropshire, TF3 3AZ England Tel: +44 (0)1952 21 3268 * Fax: +44 (0)1952 20 0981 * Email: [EMAIL PROTECTED] * Web: www.atkinsglobal.com <www.atkinsglobal.com> * This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7107 ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ********************************************************************
