Forum

Results 1 to 12 of 12
  1. #1
    Join Date
    March 2009
    Location
    Berlin
    Posts
    4

    clientDbList 200 Limit

    Hi,
    i programm a tool for give servergroups on my server. but the limit from clientDbList is 200 and i become only 200 entrys.
    how can bypass this problem ?

  2. #2
    Join Date
    January 2016
    Location
    Germany
    Posts
    14

    Query Command clientdblist is Limited to 200 clients

    The Query command clientdblist is limited to 200 clients, but I need a full List. Duration is set to 1000 but always only 200 clients.

  3. #3
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,350
    That's not a bug, that's intentional. You can still get your full list.

  4. #4
    Join Date
    March 2016
    Posts
    56

    clientdblist max value?

    Hello,

    a dev and myself found out that it seems there is a limited value in clientdblist but its not documented in the "TeamSpeak 3 ServerQuery Manual"

    The max value seems to be by 200.

    example:

    clientdblist start=0 duration=199 - works = 199 Clients
    clientdblist start=0 duration=200 - works + 1 new client = 200
    clientdblist start=0 duration=201 - sends only 200 clients // BUT -> error id=0 msg=ok
    clientdblist start=0 duration=500 - sends only 200 clients // BUT -> error id=0 msg=ok


    On some point it could destroy other databases from other scripts that trusts on the "error id=0 msg=ok"


    It would be good if the limit were either actually unlimited or at least the command should be blocked when the limit is exceeded. (and it should be official documented)


    regards


    Shadow86
    Last edited by dante696; August 21st, 2018 at 03:19 PM. Reason: moved out of bug section

  5. #5
    Join Date
    March 2016
    Posts
    56
    I think it's a pity that it seems like you have no desire to answer questions and push them into threads, hoping that they will be forgotten?!

    I mean it's been over a month now that my question has just been moved without ever getting an answer.

    So, is this fixed (fix value - 200 where no "error id=0 msg=ok" is send if the limit exceeds over 200) or adjusted (elastic)?

    regards

    Shadow86

  6. #6
    Join Date
    September 2012
    Posts
    6,076
    No, you can only receive 200 results per call.
    You can use -count and will receive how many there are in total and use start=x to continue receiving the next batch of clients.

    Code:
    clientdblist -count // gives the first 25 clients along with the total number
    clientdblist duration=5000000 -count // gives 200 clients along with the total number
    clientdblist start=200 duration=200 -count //gives 200 clients starting with the 201st client along with the total number
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

  7. #7
    Join Date
    March 2016
    Posts
    56
    Is there a reason why you can only query exactly 200 users? I think today's servers should be able to fetch 500 or even 1000 clients at once?

    This would at least (i think) speed up the process of getting a full clientlist.

    Because instead of getting 800 clients at once I have to get 4 x 200 clients

  8. #8
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,350
    Quote Originally Posted by Shadow86 View Post
    I think today's servers should be able to fetch 500 or even 1000 clients at once?
    Actually, clientdblist got way slower in 3.1.0. Until that is fixed, increasing the limit makes no sense.

  9. #9
    Join Date
    March 2016
    Posts
    56
    Quote Originally Posted by numma_cway View Post
    Actually, clientdblist got way slower in 3.1.0. Until that is fixed, increasing the limit makes no sense.
    Then maybe upgrade to the newest Version 3.4.0 - in this Version it's faster again.

  10. #10
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,350
    No, it's still slow.

  11. #11
    Join Date
    March 2016
    Posts
    56
    Quote Originally Posted by numma_cway View Post
    No, it's still slow.
    Our results:

    Values of server version 3.3.0: approx. 30 - 40min. required for 20k clients.

    Values of server version 3.4.0: approx. 06 - 08min. required for 20k clients.

    So it is definitely faster.

  12. #12
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,350
    3.0.x would be way under one minute.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [No Bug] clientdblist -count crashes TS3 server
    By lwimble in forum Bug Reports [EN/DE]
    Replies: 6
    Last Post: November 9th, 2011, 08:09 AM
  2. [Resolved] Server RC1: clientdblist count
    By neoobs in forum Bug Reports [EN/DE]
    Replies: 3
    Last Post: June 1st, 2011, 07:27 AM
  3. [Solved no BUG] clientdblist
    By Billy_the_Puppet in forum Bug Reports [EN/DE]
    Replies: 1
    Last Post: March 29th, 2010, 04:21 PM
  4. Server crashes upon clientdblist
    By SilentStorm in forum Windows
    Replies: 4
    Last Post: January 13th, 2010, 08:35 PM
  5. Output from clientdblist
    By Chillmaster in forum Server Support
    Replies: 0
    Last Post: December 24th, 2009, 01:49 PM

Posting Permissions

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