[mapguide-users] Pulling up Database resouces in Studio

[Butler, Juan P]

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/20060620/c2418607/attachment.html