[mapguide-users] Pulling up Database resouces in Studio

Thu Jun 22 09:44:50 EDT 2006

Dave:

I'm using the Enterprise builds from the Tux project on MyFeedback.
I'll check to see if there is a more current build of the software.

It takes longer than 60 seconds.   But the thing is, is that it's not
consistent.  I can work fine for a little while and then all of a sudden
I go to a standstill.   The application locks up.    Is anyone else
noticing this?   Like I said, it's not just on Access databases, but
with loading the symbol libraries, editing layers, etc.

As for my application, I guess the issue was with the point data coming
from the Access database.  If I turn those layers off, the application
works fine and the server process does not crash.   Once I start using
those layers, it's only a matter of time before the MGSERVER process
crashes.  The weird thing is, the parcel information that is in the
Access database works fine.  I use that data as an extension to the
parcel SDF file to display tooltips.  I'm just going to convert those
point layers to SDF for the time being.    

- Juan

________________________________

From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Wednesday, June 21, 2006 4:06 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

How recent is your compile, when did get the last set of code updates?
The reason I ask is that in recent weeks various performance
improvements have been checked in. If your build is a few weeks old you
may want to recompile.

Of course painfully slow is one of those phrases open to interpretation.
Does it take more than 30 seconds or 60 seconds to load a map? Are you
optimizing things by only enable layers at certain scale ranges? Or are
you having issues just initially working with the data prior to building
a complete map?

Dave

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 3:22 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

I hope it's not memory...I have 4GB of Ram on my workstation.   I don't
think its memory....if it is, Studio uses quite a bit.

Seems like it's a network issue, but I don't have network issues outside
of Studio.

- Juan

________________________________

From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Tuesday, June 20, 2006 5:12 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

Out of curiousity how much memory does your client machine have? I've
found that with insufficient memory the client swaps a lot of virtual
memory to disk.

If you have less than 512 MB of RAM and you are running Outlook and
other memory intensive apps then you won't have enough memory to open
many things within Studio.

I would use taskmanager and using the Processes tab add columns for Peak
Memory Usage and Virtual Memory size and watch their behaviour. If your
virtual memory size grows too high then your system is likely swapping
to disk too much.

Can you determine if this is the issue?

Dave

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 1:18 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

Dave:

The Access database is located on the server and I'm logging into the
server from my client machine via Studio.  It's painfully slow at times.
It seems to struggle with the databases that contain the most
information.   Smaller databases are fine.   It's not just databases
either.   It's an inconsistent manner in which it pulls up the layers,
symbols, etc.   Sometimes it's a quick process and other times I sit and
wonder if the program will respond back.    I would love to use Oracle
as the datasource, but that performance is worse.  In most cases, it
won't respond back and Studio shuts down.

I know this is still in Beta, just passing along my observations and
experiences.

Juan Butler - Senior Programmer/Analyst
GIS Applications
Pinellas County Information Systems
jpbutler at pinellascounty.org

________________________________

From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Tuesday, June 20, 2006 2:40 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

Sorry for any confusion.

The Access database should be on the server for the best performance. If
you are uploading it from Studio and using a connection string rather
than a DSN it will reside on the server. Personally I would set up using
a DSN on the server and keep the database in a local data folder
somewhere. Trying to access an Access database across a network involves
getting permissions and user rights correct which can be annoying to
resolve.

Studio can be on any machine. 

Dave

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 10:01 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

Dave:

Thanks for the response.   So you think it's best to run Studio directly
on the server?   Yeah, I'm going through a proxy on my laptop.  I don't
go through one on my PC, so I'll give this a try and see if it speeds
things up.

Thanks.

- Juan

________________________________

From: Dave Wilson [mailto:dave.wilson at autodesk.com] 
Sent: Tuesday, June 20, 2006 11:59 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Pulling up Database resouces in Studio

In general an Access database works VERY fast when it is stored locally,
remotely it's much slower. If you are on an external server do you have
a firewall and/or proxy server to contend with? This will also slow
things down.

Dave

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Tuesday, June 20, 2006 9:44 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] Pulling up Database resouces in Studio

I've moved my MGOS stuff to our external server and when trying to pull
up my Access database resources in Studio, it takes a very, very, long
time.  I'm just trying to make sure the connections are valid and
working.    Is anyone else experiencing this?   It's fine when I do
everything local.   Is this a known issue when trying to connect to a
remote server?    

FYI.  Using IIS/.NET implementation.

- Juan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060622/ab24d36a/attachment.html