+ Reply to Thread
Results 1 to 2 of 2

Thread: Query Layer performance guidance / feedback

  1. #1
    Tom Cohen
    Join Date
    Sep 2010
    Posts
    48
    Points
    7
    Answers Provided
    2


    1

    Default Query Layer performance guidance / feedback

    I've just started using Query Layers for read-only maps served-up through ArcGIS Server (10 SP2) reading data from Oracle 10g. I love it! I've always felt oddly uneasy about SDE and this seems a good sidestepping opportunity.

    In my tests performance looks good but I would like to see some documentation (ideally) or other user feedback on Query Layer performance on live services or large datasets and how it compares to other DBMS options (SDE, SDE DC).

    The only docs I've seen make a big deal out of the data being queried each time a user action occurs, but I would expect this to happen in all types of connections. Does SDE do some magical caching that a Query Layer doesn't? Does it better handle concurrent users in some way?

    If anything I would expect Query Layers to improve performance at runtime (lower overhead) and reduce development / setup time (fewer SDE configuration headaches).

    Any experience or informed thoughts on this would be very much appreciated. Please assume I am not concerned with versioning / multi-user editing, or any of SDE's other non performance-related benefits.

    Tom

  2. #2
    Tom Cohen
    Join Date
    Sep 2010
    Posts
    48
    Points
    7
    Answers Provided
    2


    0
    This post is marked as the answer

    Default Re: Query Layer performance guidance / feedback

    I asked the same question here: http://gis.stackexchange.com/questio...on-or-feedback

    I ended up running benchmark tests myself when no one could provide feedback. Follow the link for results.

+ Reply to Thread

Tags for this Thread

Posting Permissions

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