Hi, We were / are using SW for a long time and we found it very very slow, but update 5000 records in 5 hours is too much ! Are you sure you have not any Trigger en SQLServer tables ?. Are you updating many fields ? Are you updating also the object ? The link field (GEONAME) is indexed ? What MapInfo release are you using ?. Have you taken a look if a patch exist ? What SW relase are you using ?. We use SW 4.5 and 4.6. Have you taken a look if a patch exist ?.
Regards Alejandro ----- Original Message ----- From: "Karl K" <[EMAIL PROTECTED]> To: "mapinfo" <[EMAIL PROTECTED]> Sent: Monday, June 14, 2004 12:32 PM Subject: MI-L Spatialware speed to SQL Server? > Hi. > > I have a client running Spatialware and it appears to be running really slow. Is > there anyone that can let me know if there are any tips/tricks to make sure you have > it running as fast as possible. > > They have a Mapinfo table that's linked to SQL Server. When they tried to update > 5000 parcels as a one time save to the sql server table the whole process took about > 5 hours. > > They are running on a Windows 2000 Network (100mbps speed). The server runs Windows > 2000 Advanced server with two 2.6 P4 processor and 1Gb RAM. > The SQL Server table is a flat table linked to Mapinfo via an ODBC link stored on > the server. > > Any help is greatly appreciated. > > Karl > > > > --------------------------------- > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger
