[mapguide-users] ODBC Points Performance

[Ismael Cams]

I don't know if it is an option for you but it might be sufficient to put
only the x-y coordinates in an SDF together with a key that can be used to
do further database queries. These SDF's can be generated out of the SQL
server database you are using with some code.
To get properties and other information out of the database you could go
with an own faster database connection. 
For the synchronization you could run the job for exporting the geometry to
SDF every day or so.
It needs some work, but for a layer with ~ 5000 points I had sometimes to
wait up to 10s before something got selected ... 


Jon Rizzo wrote:
> 
> 
> Strange, we an ArcIMS site pulling points & other data out of a SQL Server
> database without a problem.  Moving the data to SDF is not a desireable
> solution, since we have other systems in place that rely on the same data
> being available to ODBC/SQL.  Duplicating data is certainly an option, it
> just defeats the point of having an enterprise database in the first
> place.
> 
> 
> 
> Ismael Cams wrote:
>> 
>> If you can avoid using SQL Server I would advice to not use it. It is
>> really very slow (also note to not use the Native Client driver as this
>> is not working -> tables are not showed). 
>> Connection with Access is faster but I encountered some unstabilities
>> with it. I did not investigate it further but I guess it is a problem
>> with too many connections towards the Access database.
>> I have finally transported all the data into an SDF which is working much
>> much faster.
>> 
>> 
>> Jon Rizzo wrote:
>>> 
>>> 
>>> I was told specifically the oposite - that ODBC performance of SQL
>>> Server is slower than all other ODBC providers, including Access.  I
>>> have not verified this claim, but I can tell you that selection is
>>> particularly slow with points coming from SQL Server.  I have also had a
>>> performance problem selecting polygons if they are joined with data
>>> coming from SQL Server.  I don't know enough about the problem to know
>>> if this is a MapGuide or a Microsoft issue but selection on my site is
>>> terribly slow because of this.
>>> 
>>> 
>>> Jon
>>> 
>>> 
>>> 
>>> None None-9 wrote:
>>>> 
>>>> Is anyone using ODBC to Access to display point layers on a production
>>>> server? Are there known issues with selecting and overall speed? I am
>>>> assuming yes, and if so has anyone used MS SQL for the same thing and
>>>> notices an improvment with the Enterprise FDO?
>>>> 
>>>> The Rock
>>>> 
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>> 
>>>> 
>>> 
>>> 
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/ODBC-Points-Performance-tf4201424s16610.html#a12016932
Sent from the MapGuide Users mailing list archive at Nabble.com.