You have very nicely expressed the "horses for courses" nature of DBMS access for mapping systems. A completely 'live' picture, with all users on live/cached access will hit the database hardest and give you a performance headache. Downloads hit the database less frequently but then you have issues on refreshes and keeping all users in step. My feeling is that uncustomised MI Pro is too powerful/open/uncontrolled to manage this - the same is true of competing products.
It is worth getting advice on tuning the database for live access - from 9i onwards there are more resources within Oracle and the user community to draw on - I'd recommend searching this list via the Directions magazine site for other users experience. You need to look at how much data actually needs to be stored and accessed live, how often the users need to refresh, and how much functionality each client needs to support. This is different place to place and customer to customer. We have gone down the downloading route on a particular big system via a customised integrated mapping application (ie not exposing full MapInfo functionality). Not quite as big as yours but user numbes of the same order of magnitude. This is a brief summary of why and how - 1) A lot of the data is effectively static - in our case large-scale mapping used as a backdrop. This is NOT accessed live but out of ordinary MapInfo TAB files stored on file servers around the LAN. We bring these servers up to date on a weekly basis using a dedicated EXE. This means that database queries/refreshes are limited to a small subset of layers that for business reasons HAVE to be live to all users. There are big performance gains in this area. 2). Because its a customised app, our users get downloaded map data for editing on their client that is 'checked out' to them and that other users can see but not interact with until it is checked back in. So they don't need to perform a refresh until they are finished and the check in is taking place. The overhead on performance is still there but it comes less often. Users like this because it makes sense in a 'start work/stop work' setup. 3) Printed output is handled through a separate process (actually another version of the same EXE) on a dedicated server on a queue and is not handled by the individual client processes. This simplifies tuning (hardware/software) for different purposes. Hope this helps - Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: tuncay [mailto:[EMAIL PROTECTED] Sent: 23 December 2003 13:38 To: 'MI-List' Subject: MI-L Multiuser data editing. Hi there we have GB level vektor data. System will be designed for country side. Each city will edit their region. In total we have more than 1000 user. In capital there will be 80 concurrent user. Each user has to get A0 printout. Network is 2Mbit. What kind of system design can you offer. Current design & limitation: we use oracle 9i spatial with mapinfo. All vekt�r data is in Oracle spatial. tables are indexed according to region no and there is one table for each layer. Users download their responsibility area by sql select. Live or cahce access are slow in pan and zoom. Downloaded data is fast in pan and zoom but refreshing table(synchronizing with server) is very slow. Each time minimum 10 seccond. When data is in file server speed is increadibly nice. But multiuser is headache. Thanks for any help --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9687 ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ********************************************************************
