MapForums
Community of VE/MapPoint Users and Developers
Performance: UDL vs Access Linked table
This is a discussion on Performance: UDL vs Access Linked table within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I have a large database in SQL 2000 and have defined a view representing the dataset I would like shown ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
10-19-2004
| |||
| |||
| Performance: UDL vs Access Linked table Using a linked table (pointing to the SQL View) in MS Access, the data loads into the map in about 1 min 40 sec Using a UDL with Provider=SQLOLEDB.1 load time was about 2 min 50 sec Using a UDL with Provider=MSDASQL.1 load time was about 3 min 30 sec I ran multiple tests in varying order to rule out caching on the server. Given the number of tests I ran, I'd be surprised if other network traffic had anything to do with it. The SQL server was idle other than for my requests. Has anyone else seen this type of performance difference? Any suggestions to enhance the UDLs performance? kirk dot dybvik at us dot benfieldgroup dot com         |
 |
| Tags |
| access, linked, performance, table, udl |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I link an Excel pivot table with Mappoint? | Anonymous | MapPoint 2006/2009 Discussion | 0 | 10-27-2004 05:19 AM |
| how to export the data of an Excel table on a chart mappoint | Anonymous | MapPoint 2006/2009 Discussion | 0 | 02-17-2004 05:37 AM |
| Import a Table From Microsoft Access | awiora | MapPoint 2006/2009 Discussion | 0 | 10-21-2003 08:51 AM |
| Trying to add pushpins for specific table data | Anonymous | MapPoint 2006/2009 Discussion | 2 | 10-02-2002 08:37 PM |
| Is there a way I can put datasets linked to an Acc.... | Anonymous | MapPoint 2006/2009 Discussion | 1 | 11-13-2001 06:45 PM |
All times are GMT -5. The time now is 02:33 AM.
