Ian, If our experience is anything to go by, then the answer is you can't. The Local Authority that I work for have been using MapInfo for 7-8 years now. One of the major uses it is put to is for the capture of Planning Applications and Local Land Charge searches. This is done via various MapBasic Modules. However, as this is a multi user system, we had been experiencing problems with file locking (data capture is done locally, but then is committed to the server when the user is happy). This means that on occasions a users machine fails to release one of the MapInfo files (usually the .id), causing a lock on the table which can only be released by the offending user logging out. As we have approximately 140 users, this can be problematic.
The solution as we saw it was to move to Spatialware for SQL Server as SQL Server is our chosen database in ICT (also we have no Oracle servers or DBA's in the authority, and they are also expensive). We initially had Spatialware installed in April, but we keep hitting problem after problem (mainly caused by the shocking lack of literature and information out there). However, the biggest problem is this indexing problem. Linked tables, no problem as they are virtually Native tables, so you can add an index to a column through table->maintenance (creating an .IND file, which allows the column to be searched via the find routine). However, the Live tables (which we need to use to overcome this locking problem) do not allow this (the boxes are greyed out), so it although you can add an index to the column in the SQLServer back end which means a select query completes almost instantaneously, when you try and run the same SQL through MapInfo, there is no index, hence the query falls over as it is having to do an entire table scan. Unfortunately for us, running select statements on moderately large tables (between 80,000-150,000 records). Therefore, as it stands it is useless as we require the modules to do several select statements through MapInfo (I must state that there are no problems doing a graphical select, the R-Tree Index on the geometry works absolutely fine). We are told that this glaring omission of being unable to add an index to a live table has been addressed and will be part of the next release V4.6, which I believe will be available in the UK and also in Australia and New Zealand I believe some time next month (although I have had one or two conflicting reports, this seems to be the most common answer). Until then, it is sit tight and hope that the problem is resolved, although whether it will allow you to use the find utility in ProViewer, we will have to wait and see. I would also be interested to hear yours and anyone else's experience with the above product. We are flying a little bit blind when it comes to Spatialware (as many others are I'm sure), so I'm sure we can all benefit from helping each other out. Regards, Mark. -----Original Message----- From: Ian Tidy [mailto:IanTidy@;linesmarl.co.nz] Sent: 11 November 2002 22:11 To: MapInfo-L (E-mail) Subject: MI-L SpatialWare Searching Hi We have implemented SpatialWare 4.5 for SQL Server. We run a combination of MapInfo 7 and ProViewer 7. The problem I have is that we can't search the SpatialWare tables from ProViewer (unless we include a query in the workspace). I would like to use the 'Find' function in both MapInfo and ProViewer, but I understand that this requires the 'IND' index files. So my questions is this, how can I use the 'Find' function with SpatialWare (and create the index files without creating copies of what is in SpatialWare)? Cheers Ian Ian Tidy Network - Technical Assistant Marlborough Lines 1 Alfred Street, P.O. Box 144, Blenheim, New Zealand Phone + 64 (3) 577 7007, Fax + 64 (3) 577 7014 DDI Phone +64 (3) 579 3831, Mobile + 64 (27) 283 1862 mailto:IanTidy@;linesmarl.co.nz http://www.marlboroughlines.co.nz This e-mail is only intended to be read by the named recipient. It may contain information which is confidential or subject to legal privilege. If you are not the intended recipient you must delete this e-mail and you may not use any information contained in it. Legal privilege is not waived because you have read this e-mail. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal. ##################################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4021 This communication is from Wakefield Metropolitan District Council Confidentiality: This communication may contain information that is confidential and/or privileged and is for the exclusive use of the intended recipient(s). Any form of distribution, copying or use of this communication by anyone else is strictly prohibited. If you have received this communication in error please reply to [EMAIL PROTECTED] or telephone +44 (0) 1924 305444, and destroy any copies of this communication. Security: This communication has been created and is sent in the knowledge that Internet e-mail is not secure. We strongly advise you to understand and be aware of this lack of security when e-mailing us. If you communicate with us by Internet e-mail, we will assume that you accept the security risk and that you authorise us to communicate with you in the same format. Viruses: Although this e-mail and its attachments are believed to be free from any virus, it is the responsibility of the recipient(s) to conduct their own virus checks on all parts of this communication. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4031