[mapguide-internals] sp_cursorfetch

[Zac Spitzer]

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