Page 1 of 1

apperyDB: maximum length for query

Posted: Wed Nov 30, 2016 7:20 am
by EJLD

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


apperyDB: maximum length for query

Posted: Wed Nov 30, 2016 10:11 am
by Serhii Kulibaba

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


apperyDB: maximum length for query

Posted: Wed Nov 30, 2016 11:47 am
by EJLD

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 ?


apperyDB: maximum length for query

Posted: Wed Nov 30, 2016 1:40 pm
by EJLD

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


apperyDB: maximum length for query

Posted: Thu Dec 01, 2016 8:08 am
by Serhii Kulibaba

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...


apperyDB: maximum length for query

Posted: Thu Dec 01, 2016 10:24 am
by EJLD

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