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.

      • Willem's avatar
        Willem
        Guide
        ClaudiusH I dont know, but wouldnt be surprised if it is. When i joined the team there where already queries with custom limits.