Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

We have a number of SQL Spatial views each made up of approximately 10 tables (so relatively complex views) and each including a table with a SQL Geometry column. A view could return up to 300-400 thousand records. No SDE involved. We are using a Query Layer (QL) for each spatial view (Select * from the view) to display in ArcMap. Each spatial table has a primary key, spatial grids and uses an SRID of 0. Just to load a QL might take 10-15 seconds. To display with a 100k - 250k data view (maybe 100s of features) takes 10-20 seconds. We previous had these as SDE views (same underlying SQL views w/o the SQL spatial column) in Arc 10 and they loaded and displayed in 1-3 seconds.

Anyone have ideas about why these are SO MUCH SLOWER without using SDE?

share|improve this question
add comment

2 Answers

I don't know if this could help but when using Query Layers on ORACLE Views with an SDO column, we had to create Spatial Index on all tables containing Spatial information, and then create a spatial index on the view.

share|improve this answer
1  
Thanks for the quick response and a good idea. We have indices on the spatial tables but not on the views. In fact we were talking around this point this afternoon. I'll put an index on one of the larger views first thing Monday and let you know. –  Michael Ciscell Mar 3 '12 at 0:22
    
@MichaelCiscell were you able to create the index on your View? –  Dom Mar 13 '12 at 17:41
    
No. Sorry fro being away from this so long. We're working with ESRI now on the issue. Our views had issues an Indexed View didn't allow. –  Michael Ciscell May 11 '12 at 22:40
add comment

My suggestion would be cut down on fields you are selecting instead of

Select * from the view

which gives you all the rows and all the columns of the tables in question cut down on what you are selecting:

Select Fruit,Tree,Branch From Orchard Where Tree = 'Apple'

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.