EJLD
Posts: 0
Joined: Sun Jun 08, 2014 11:03 pm

apperyDB: maximum length for query

Hi There, it could be a strange question but is there maximum for a query.length in apperyDB or serverCode ? concretely, it seems like my query.length is blocked at 100. wld it make sense to you ? thk you for your advice in advance, Eric

Serhii Kulibaba
Posts: 150
Joined: Tue Aug 27, 2013 1:47 pm

apperyDB: maximum length for query

Hello,

Appery.io doesn't limit that, it might be blocked by your browser. Please use POST requests if you need to send a lot of data to the Server Code. You can use long list of parameters in it's body

EJLD
Posts: 0
Joined: Sun Jun 08, 2014 11:03 pm

apperyDB: maximum length for query

it's in the server code. it looks like the query array cannot be longer than 100. I found the way to bypass by querying several times but it's quite annoying to develop special loop for that. do you see something there limitating ?

EJLD
Posts: 0
Joined: Sun Jun 08, 2014 11:03 pm

apperyDB: maximum length for query

i coded a bypass query < 100 records (objects) at once. however, if you have an idea why .length<=100, then tell me :)

Serhii Kulibaba
Posts: 150
Joined: Tue Aug 27, 2013 1:47 pm

apperyDB: maximum length for query

This is default limit of Appery.io database. You can set your own with a request parameter "limit". Please look here for more information: https://docs.appery.io/reference#data...

EJLD
Posts: 0
Joined: Sun Jun 08, 2014 11:03 pm

apperyDB: maximum length for query

thk you very much for your feed back. that's clear. I'll made a bypass for that script but foresee the same issue when entering in production with several other scripts. i'll reset the limit to more records instead. best

Return to “Issues”