I have a app that searches an SQL table of over 10,000 rows. The lookups are very slow. I want to pull that table into a collection so it speeds it up a bit. However, the table is only 2,000 rows with clearcollect(). I thought that an SQL table was not like a sharepoint table. That you could have more rows than 2,000. We figured out how to get 4,000 rows from a SP table via this post:
https://powerusers.microsoft.com/t5/General-Discussion/Collections-maxes-out-at-2000-when-populating-with-SharePoint/m-p/179585#M59406
I was hoping to get a larger SQL table. Perhaps I can make an index, and grab them 2,000 at a time using some GT/LT scenarios with the index.
More later... unless someone has a better idea.
