Default value of 999999 seems unreasonable high. It would kill server and db pretty quickly if many users start clicking links provided in the api documentation, or multiple clients start calling api without pagination params.
Even 1000 seems very high, presuming the limit is set per-timeout perspective and that time difference is not too high.
250 seems better based on the normal db standards.
Default value of 999999 seems unreasonable high. It would kill server and db pretty quickly if many users start clicking links provided in the api documentation, or multiple clients start calling api without pagination params.