+ Reply to Thread
Results 1 to 4 of 4
This is a discussion on MySQL Upsert Question within the Salesforce PHP Tutorials forums, part of the Salesforce category; Hi there, Ignore my previous question.. I was able to do an
  1. #1
    Kevin Davis is offline Junior Member
    Join Date
    Aug 2010
    Posts
    5

    MySQL Upsert Question

    Hi there,

    Ignore my previous question.. I was able to do an upsert, however, I'm seem to be stuck at the 200 record limit. Is there a work around?


    Thank you,
    Kevin Davis
    Last edited by Kevin Davis; 02-09-2011 at 01:34 PM. Reason: Change in question

  2. #2
    mike's Avatar
    mike is offline Administrator
    Join Date
    May 2007
    Location
    Wylie, Texas
    Posts
    607
    Blog Entries
    16

    Question

    what do you mean exactly man? Are you only processing a total of 200 records or 200 at a time ?

  3. #3
    Kevin Davis is offline Junior Member
    Join Date
    Aug 2010
    Posts
    5
    Sorry I should have been more clear. I have a data set that has more than 200 records and when I reach the 200 limit it stops.

  4. #4
    Adam Best is offline Junior Member
    Join Date
    Apr 2011
    Posts
    10
    Hi Kevin,

    Yes, some Objects have their own restrictions on how many records it queries at a time and even though you put a higher number, SalesForce will override your perference. I usually set the batches at 1000 per query as this is a safe number. I think 2k is about the maximum you can go.

    Now, about your stopping issue, this just means that you need to use the queryMore method instead of the query method.

    Why don't you take a look at the page below for an example of this:
    PHP Toolkit 13.0 QueryMore Sample (Partner) - developer.force.com
    Regards,
    Adam

    Into Joomla! and SalesForce?
    Check us out below at
    http://www.miiworks.com/

+ Reply to Thread

Similar Threads

  1. What's your question?
    By Willis in forum Salesforce PHP Tutorials
    Replies: 0
    Last Post: 04-13-2010, 08:33 PM
  2. upsert question
    By jeff in forum Salesforce Coding Discussions
    Replies: 2
    Last Post: 08-12-2009, 03:33 PM
  3. PHP Toolkit Security Question
    By PaulC in forum Salesforce PHP Tutorials
    Replies: 3
    Last Post: 08-12-2009, 12:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO 3.5.2