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
