Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 0 down vote favorite

I am creating a block wise vector layer and related data stored in a sql database while retrieving the data from the SQL database through querying and would represent the result on a map. This is taking a lot of time and there is no problem with the data structure because it performs all statistical operations very quickly. What is taking time is the processing required to represent the result on the map. Database is sql server, software used Map Suite GIS Editor, no wms, Does anybody have suggestions as to what the problem might be and what is the possible solution?

share|improve this question
1  
which is your database? postgis/oracle? what does your current query look like? how much is the data and how much time does it really take? mentioning these things could help you get an answer – vinayan Feb 9 at 12:36
1  
And what is the path of the data from database to map? some service like wms? what software? what network? The bottleneck can be almost anything from the question. – Nicklas Avén Feb 9 at 13:03
2  
We need more background info on this question (database, amount of rows, indexing) on this question to help answer it. – Mapperz♦ Feb 9 at 20:16

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.