http://forums.method.me/cs/forums/15.aspxAsk questions specific to the MethodAPI from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/12936.aspxSun, 01 Jul 2012 16:14:53 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:12936Method_Paul0http://forums.method.me/cs/forums/thread/12936.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=12936<p>FYI - to anyone reading this. This was changed from a 10k limit to a 1,000,000 cell limit.</p> <p>So if you have only 10 fields you are pulling out, we allow up to a 100k record pull at a time.</p> <p>Paul</p>http://forums.method.me/cs/forums/thread/12534.aspxThu, 31 May 2012 14:00:34 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:12534Method_Paul0http://forums.method.me/cs/forums/thread/12534.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=12534<p>API&#39;ers.</p> <p>In rare situations where you are pulling a large number of records, please know that we had to put in a 10,000 record limit in place. </p> <p>If you have to pull more than 10k records, please do it in iterations, so:</p> <p>1. Grab desired records.</p> <p>2. If record count is less than 10,000, then great, you&#39;re done.</p> <p>3. If record count is 10,000, repeat your query, but this time add WHERE RecordID &gt; 123 (replace 123 with the highest RecordID from your previous query).</p> <p>4. Repeat step 2 and 3 until you have all the records you need.</p> <p>&nbsp;</p> <p>Of course, for pure efficiency, best practice has always been to make good use of filters so that you only pull what you need in the first place.</p> <p>Paul</p>