Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

Increase the maximum of 1000 records that can be returned in SQL

  • 1.  Increase the maximum of 1000 records that can be returned in SQL

    Posted 9 days ago
    Hello everybody,

    I would like to know how to increase (or delete) the maximum of 1000 records that can be returned in a selection SQL. Also, is it the same for the maximum of fields?

    Thnaks you,

    Augustin

    ------------------------------
    Augustin Boyer
    GEO RM
    Jaunay-Marigny
    ------------------------------


  • 2.  RE: Increase the maximum of 1000 records that can be returned in SQL

    Pitney Bowes
    Posted 9 days ago
    Hi Augustin,
    you can configure this parameter within the Spatial Manager in Spectrum.
    Go to http://spectrum_host:8080/SpatialServerManager
    Login as an admin.
    In the banner go to Services=>Feature
    Here you will be able to increase the maximum of features returned.

    If you mean with 'maximum of fields' the number of columns that a layer can contain, I doubt there is a limit. Nevertheless the tab file itself has a limit. There isn't a hard limit for databases. Just bandwidth, memory and processing power.

    Regards

    Andreas

    ------------------------------
    Andreas Homa
    PITNEY BOWES SOFTWARE, INC
    Troy NY
    ------------------------------



  • 3.  RE: Increase the maximum of 1000 records that can be returned in SQL

    Posted 9 days ago
    I maybe misspoke. I talked about a SQL request in a angular development. I thought that there are a limit a columns and records that can be returned.

    Thanks you,

    Augustin Boyer

    ------------------------------
    Augustin Boyer
    GEO RM
    Jaunay-Marigny
    ------------------------------



  • 4.  RE: Increase the maximum of 1000 records that can be returned in SQL

    Pitney Bowes
    Posted 8 days ago
    If you use the Feature Service in your angular development, like http://spectrum:8080/rest/Spatial/FeatureService/tables/features.json?q=SELECT * FROM "/Samples/NamedTables/WorldTable" WHERE Country='CANADA' than the proposed way of increasing the maximum number of features will help you.

    Again there is no limitations on the number of columns returned.

    ------------------------------
    Andreas Homa
    PITNEY BOWES SOFTWARE, INC
    Troy NY
    ------------------------------