>I am currently assessing the feasibility of moving our MapInfo dataset to an >Oracle8i back-end database. Does anybody out there have any experience of >using Oracle8i to store GIS data. Yes, we have, and quite a few of MapInfo's Partners in the UK have been trained on Oracle8i Spatial and MapInfo integration. >I am particularly interested in the performance of spatial queries, Of course, they entirely depend of data volumes, how many concurrent users and size of your system in terms of CPUs and memory available. We have no generic benchmarks available, but depending on your requirement, we could look to help out with your assessment of this environment. >multi-user capabilities, This is exactly what the MapInfo Professional and Oracle8i Spatial integration provides. MapInfo Professional, MapX and MapXtreme/Java are all now using NATIVE Oracle8i Spatial connectivity (via Oracle Call Interface = OCI). In MapInfo Professional we provide both a "download" as well as a "live access" model supporting multi-user concurrency and transactional insert/update/delete functionality at record-level ! >No. of Oracle concurrent licenses required That depends of how many users you expose to your application and what your chosen deployment will be (i.e. client/server setup or web-based). >and what the trade-offs in terms of license requirements over performance are >when using linked or live tables. If I understand this question correct, there will be no difference in license requirement whether you are using linked or live access tables. In both cases you'll need the same amount of licenses. In terms of performance, generally, you'll probably perceive the "linked" scenario to be faster (especially on small data volumes), - however the beauty of "live access" is that you can limit the data-retrievel to the "current mapper window" (provided you have a unique index on your dataset) and therefore "live access" will accelerate on big data volumes. ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
