www.webdeveloper.com
Results 1 to 2 of 2

Thread: SQL Server indexing for GIS systems

  1. #1
    Join Date
    Apr 2006
    Posts
    219

    SQL Server indexing for GIS systems

    Hi,

    I am working on a GIS project where we locate the objects using for coordinates CURX (Upper right x point), CURY (Upper right y point), CLLX (Lower left x point), CLLY (Lower left y point). When the table row numbers are low, maps work fast. But when the numbers go upto 100-200 thousands or more maps become really slow. Considering that the GIS server needs to draw multiple layers the response times become a nightmare.

    Could anyone recommend an advanced indexing for this kind of GIS project?

    Many thanks
    telmessos

  2. #2
    Join Date
    Oct 2009
    Posts
    658
    Can you provide the relevant table structure. Next have you identified that the real bottleneck is the database operations. Most often I find it that the image rendering is the bottleneck for GIS systems.
    Good Luck

    Santos Systems

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles