Hi friends,
I created an application, having a map containing SDF connection which is
having very good performance but when i am using same map with sql server
spatial provider connection map performance became very poor.
i want to use RDBMS connection in my application because i have to do some
what's your server setup? separate db server?
File based providers have much less overhead and
outperform DB servers period.
sqlite is by far the best, roughly 3-4 x SDF, 20-40x RDBMS
best approach is too keep static data in sqlite,
dynamic in RDBMS
z
On Wed, Apr 6, 2011 at 10:21 PM, prabhat30
Try using MySQL. It's pretty quick.
Dave
-Original Message-
From: mapguide-users-boun...@lists.osgeo.org
[mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Wednesday, April 06, 2011 6:42 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] RDBMS conne
Hello mapguide friends,
I am running mapguide 2.2 RC4 and maestro 3.0 b3! The spatial information I
have Is in a oracle database and in the Swedish coordinate system SWEREF (99
12 00): EPSG 3007. Now I want to combine this with Yahoo or Google maps in a
fusion layout.
In the map definition I
ECWs seem to be working ok for me in the latest release of 2.2 (RC4). I had
some problems with earlier release candidates. Were you using these same
ECW and SHP files in 2.1? Did you have any problems? If you were using 2.1
and it was working fine, I suggest creating a package and loading into
Don't be so quick to down SQL Server. Make sure you have correct spatial
indexes. Make sure the geometry is valid. It is quick, you just need to make
sure you are using it properly. in my experience, it is
MUCH quicker than file based.
Martin
From
Agreed.
You shouldn't automatically dismiss SQL Server's performance (or any other
RDBMS) just because MapGuide may give a very bad impression of it.
There are entire books written and tons of Google results about this
particular subject (DB design and optimisation). All MapGuide does is issue
q
In the limit, fetching data from an in-process, close to native representation
(e.g. SQLite) will significantly outperform an out-of-process (and possibly
remote machine) based RDBMS, at the very least due to the latency and
inter-process communication involved.
One could claim that the perfor
Thanks for that great explanation Traian!
I would suggest that PostGIS is probably the best choice if your going
to pick a spatial database server, as it's the most complete free
actively maintained
implementation, plus outperforms Oracle ( google FOSS4G WMS Shootout stats)
z
On Thu, Apr 7, 2011
You should not blindly call the GetXXX() methods from the MgFeatureReader
Call IsNull() on the reader first to determine if the property of the
current feature being read is null
- Jackie
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/SOS-Value-for-Geometry-property-is-
Use the Feature Source preview functionality to inspect the Class Definition
of your feature source.
Verify that a property named "featid" exists and is of the same case (ie.
Not "featID", "FEATID", etc)
- Jackie
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/An-excepti
Dear All,
Hi everyone, I really need your favour regarding this url thing. First of
all i'm using mapguide open source 2.2 and mapguide maestro 3.0 beta1. the
question is how can i set the url so that it wont use the session. coz
everytime the session expire i cannot see my map already. What should
from the flexbile layout editor, there is a form field url which has
the resource name
rather than the session
On Thu, Apr 7, 2011 at 4:08 PM, bjoseph82 wrote:
> Dear All,
> Hi everyone, I really need your favour regarding this url thing. First of
> all i'm using mapguide open source 2.2 and mapg
Sorry Zack, where can i find the flexible layout editor please
On Thu, Apr 7, 2011 at 2:13 PM, Zac Spitzer wrote:
> from the flexbile layout editor, there is a form field url which has
> the resource name
> rather than the session
>
> On Thu, Apr 7, 2011 at 4:08 PM, bjoseph82
> wrote:
> > Dear
in maestro, in the fusion editor page
On Thu, Apr 7, 2011 at 4:26 PM, brenda joseph wrote:
> Sorry Zack, where can i find the flexible layout editor please
>
> On Thu, Apr 7, 2011 at 2:13 PM, Zac Spitzer wrote:
>>
>> from the flexbile layout editor, there is a form field url which has
>> the res
15 matches
Mail list logo
