You need to sign in to do that
Don't have an account?
cpatel
Read a large number of rows
What is the best way to read a large number of rows? RIght now i am using the REST API query. e.g. q='Select Id from Account'
Then i am iterating through the ids and getting each row separately.
Why don't you just query the fields you want when doing the query, instead of making a round trip for each row ?
We need all the fields so thats why i'm readin the whole row. I understand that SOQL does not support a Select * ?
It doesn't support select *, but you can build a soql query with all the fields in. (use the describe resources if needed) you don't want to fetch a large number of rows by getting them one at a time, it'll be horribly slow, and it'll burn through your api call allocation very quickly