You need to sign in to do that
Don't have an account?
jayam
manage 100 millions of record in Apex
Hi,
How can I manage /Access /Update 100 millions of records in Apex .
Is it Possible using Batch Apex?
I think batch apex can Process 50 millions of records.
how can I do this?
any help?
Thanks
My recommendation for you would be to use batch apex which can work on up to 50 million records. To work on 100 million, you'd have to logically split up your jobs into smaller chunks and run multiple batch jobs.
What exactly do you want your batch job to do on such a large data set?
All Answers
My recommendation for you would be to use batch apex which can work on up to 50 million records. To work on 100 million, you'd have to logically split up your jobs into smaller chunks and run multiple batch jobs.
What exactly do you want your batch job to do on such a large data set?
Thanks for your reply Spraetz....
how can I split my data to run multiple batch jobs?
All the data we have to query in Start method
but the Scope of Database.queryLocator is 5o million .
how can we call start method multiple times to query remaining Data?
Can u Send any example? plzzzzz
thank u.....
Below is sample code of JavaScript API to retrieve millions of records:
<script type = "text/javascript">
var __sfdcSessionId = '{!GETSESSIONID()}';
</script>
<script src="../../soap/ajax/19.0/connection.js" type = "text/javascript"></script>
<script type = "text/javascript">
var a = 0;
sforce.connection.batchSize = 200;
queryResult = sforce.connection.query("Select Id, Name From Target__c Where StatusId__c = " + "'" + OptionValStatus + "'");
while(a < queryResult.size)
{
if(a != 0)
{
queryResult = sforce.connection.queryMore(queryResult.queryLocator);
}
var records = queryResult.getArray('records');
var TargetToAddArr = new Array();
for (var i = 0; i < records.length; i++)
{
var Trgt = new sforce.SObject("Target__c");
Trgt["ID"] = records[i].Id;
Trgt["StatusId__c"] = OptionValStatusCurr ;
Trgt["StageId__c"] = OptionValStageCurr ;
TargetToAddArr[i] = Trgt;
tot++;
}
sforce.connection.update(TargetToAddArr);
a = a + 200;
}
</script>
You can also retrieve more than millions of records using batch apex.
Thanks for your Reply Pradeep.
I want to manage more than 50 milllions of Records throurh Batch Apex only
How can i do this ?
if u Know Please share with me
thanks:
Jaya.
Look Here (http://neerajgupta999.blogspot.de/2012/07/automate-bulk-data-loading-through.html) or some one else
best regards john s.