Hi, I would just like to ask how can I improve performance of querying objects and also considering joining of objects? I found bridging from Rollbase to another language slower than just querying it inside the Rollbase application. Thanks.
I need to know more about your app in order to give any suggestions.
Thanks to your reply Sir Pavel.
Well, what I'm trying to do is by using the REST API feature of the system, I should be able to fetch data from our Accounting system(which includes numerous account codes, invoices, and journal vouchers). From there, I need them to be populated to tables in PHP language.
Also, I would just like to ask how can I be able to retrieve formula field values especially if this contains merely computations without even computing it again through REST API.
Formula fields are not stored in the database and cannot be retrieved through Query API. However you can use Expression fields instead.
what Expression or form field do you mean? should I query it again?
Also, please consider answering too my other questions:
1. Is md5 supported in reading password to login API, so that every user can use different session IDs?
2. how can I fetch formula field values in terms of better performance of querying using REST API? what field, in specific, should I be using in serving the same purpose of my computations in formula field?
- tried by using getDataObj API, and so far works.
3. how should I be joining objects in terms of better performance of querying using REST API?
4. how should be able to count number of rows of my query?