[mapguide-internals] sp_cursorfetch

[ljv]

The data is dynamic, it's based on current status of objects and the
effective userrights to a single object. I do not think we can prepare a
table with the data. There is around 20k of objects, most of them can be
displayed at the same time. So I get in worst case 20k of unwanted trips to
the sql server.




zspitzer wrote:
> 
> how dynamic is the data?
> 
> you may find just creating a table from the view + indexing solves the
> problem
> 
> z
> 
> 
> On Mon, Nov 24, 2008 at 11:40 PM, ljv <johan.vikstrom at gmail.com> wrote:
>>
>> We are running on an IIS server and has a MSSQL server as database.
>>
>> Since the data query is to complex to build in mapguide we use a view.
>>
>> When we test we find that the use of sp_cursorfetch when reading the data
>> causes massive cpu load and it is extremly slow.
>>
>> Is there anyway to get the mgserver to bulkread data instead of single
>> fetching, or perhaps to use storedprocedures, ?
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/sp_cursorfetch-tp20317839p20317839.html
>> Sent from the MapGuide Internals mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> mapguide-internals mailing list
>> mapguide-internals at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-internals
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com
> http://ennoble.dreamhosters.com/mapguide-central/
> +61 405 847 168
> _______________________________________________
> mapguide-internals mailing list
> mapguide-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-internals
> 
> 

-- 
View this message in context: http://www.nabble.com/sp_cursorfetch-tp20317839p20662030.html
Sent from the MapGuide Internals mailing list archive at Nabble.com.