Forum Discussion

shhouji's avatar
shhouji
Mentor
8 years ago

What is the LIQL Maximum response Limit ?

I am trying to use the LIQL api v2 to get the tags with respective a post.

 

I want to know what is the maximum number that we can pass to the 'limit' attribute. 

  • I succeeded on messages with
    - 1000 (2 sec )
    - 2000 ( 15 sec )
    - 5000 ( ~1 minute )

    [community]/api/2.0/search?q=select%20*%20from%20messages%20limit%205000

    Didnt test higher.. cause it would take to long for normal users anyway.
    • ClaudiusH's avatar
      ClaudiusH
      Khoros Alumni (Retired)

      Willem Do you know if this limit was every increased for your community?

       

      Because according to the LiQL documentation on the pagination parameters:

      The default page size allowed in LIMIT is 25. You can file a ticket with Lithium Support to change the default.

       

      Also: shhouji can you please specify what exactly you are looking for via the API? Are you looking to simply get the tags for a specific message? Or are you looking to get the list of tags for multiple messages?

      Because depending on what you are looking for there might be a lot of optimization potential for your LiQL query, e.g. by using GROUP BY etc.

      • shhouji's avatar
        shhouji
        Mentor

        ClaudiusH we had an issue with the Rest API v1 when we were trying to fetch the tags if they were more than 1000. As we need to make multiple calls in order to get this details if the limit exceeds more than 1000 with v1.

         

        And i saw that we can get more details with LIQL with a single API request and my request here is what is the maximum number for the Limit that can be passed to the api. Is it 2000 or 5000 or more, i want to know what is the maximum count that i can use for the limit ?