Using 2.5 on 5.1.1
Have large database 20k plus
trying to improve preformance by limiting returned results to a sub set of the whole. But as soon as I limit the number say to 1000 then it only ever looks at the first 1000 records. ie when this is set many searches fail because they are not in the avaiable record set.
Is this an error or do I miss understand the feature