Vinesh, When using OS MasterMap in an Oracle/MapInfo configuration you will notice a performance hit on the basis that the data is more voluminous than you would be used to with Land-Line. Some things to consider are:
Specification of database server - are you able to increase processing power or provide more memory for it? Network - A system will only ever be as fast as it's slowest component! Does your network have good bandwidth to the clients that use the OS MasterMap data? Tune the database - is your Oracle database as tuned as it could be? Have you got an index on the MI_PRINX column, is the spatial indexing tuned? Area of interest - are you asking for a reasonable amount of data in one hit? Have you tried tweaking your zoom thresholds? I would not be entirely surprised that you notice a difference when using OS MasterMap, but I am surprised that you notice an impact when using Points of Interest. This is only a points layer and so should be relatively quick when panning and zooming, certainly much better than OS MasterMap. This leads me to think there must be some other area you can tweak as in the suggestions above. Have you spoken to the supplier of your Oracle data loader for advice? Regards, ================================== Colin Henderson GI Consultant (South West) Pre & Post Sales Support Ordnance Survey Romsey Road Southampton SO16 4GU Tel: 05511 400842 Mob: 07771 972307 Email: [EMAIL PROTECTED] ================================== -----Original Message----- From: Vinesh Govind [mailto:[EMAIL PROTECTED] Sent: 25 July 2005 14:27 To: [email protected] Subject: MI-L MapInfo and Oracle Spatial - Speed and Performance MapInfo Users We are using MapInfo Pro (v8) to access Oracle Spatial (9i/10g) tables from our Corporate GIS server. One of the issues we are grappling with is the slow speed and response times we are getting when accessing the spatial tables. We have tried setting zoom layering on each of the tables but this has had little effect in improving speed when panning and zooming. This situation is particularly pronounced when using Ordnance Survey Mastermap data and recently the same poor speed has been evident when using Points of Interest data. Is anybody in the same predicament? Do you have any suggestions? Thanks. Vinny _______________________________________________________________________ Leicestershire County Council - rated an 'excellent' council by the Audit Commission _______________________________________________________________________ This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received. Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000. The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council. Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment. This email and any attachments have been virus checked upon receipt at Ordnance Survey and are free of all known viruses. This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person. Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice. Thank you for your cooperation. Ordnance Survey Romsey Road Southampton SO16 4GU Tel: 023 8079 2000 http://www.ordnancesurvey.co.uk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17252
