Perhaps this is a similar problem, but we are having problems when matching
tables of large numbers of Postcode based records to our Mapinfo Postcode
table (Geocoding effectively). For a few thousand it can take 5 to 10 mins
for 50k plus the system all buts stops.
Any ideas, anyone?
Thanks - Andrew Whittam
Dunn Humby Associates
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 05, 1999 1:52 PM
> To: [EMAIL PROTECTED]
> Subject: MI Re: SQL queries
>
> Help please...
>
> We are a local UK council new to MapInfo, (but not new to GIS), with
> one licence which we are using to evaluate the product with the
> potential to use it more widely.
>
> I am running MapInfo on my Viglen PC P5/75 with 2x 0.5GIG hard drive
> and 64MB RAM. MapInfo is installed on the D-drive, as is the data I
> am using.
>
> I am getting into situations using SQL Select where MapInfo is not
> responding & I have to close it down & clean up the .tmp files each
> time.
>
> I am searching a table of 4,800 address records for records not
> contained in another table of 3,800 records, and the processing never
>
> finishes.
> ie
> select * from table_a where not data1 in (select data1 from table_b)
>
> the data from table_a originates from an ACCESS .MDB database, the
> data from table_b originates from gradually selecting a series of
> points in MapInfo & appending them to table_b as part of a quality
> checking process. Both tables can be browsed OK independantly.
>
> I have similar "timeout" problems where using select on a 58,000 row
> address file when trying to do a simple SQL select on posttown i.e.
> select * from table where posttown ="portsmouth". Again I can browse
> the whole table. - The data again comes from ACCESS .MDB.
>
> Any advice, please? Thanks. Linda Williams
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
