Several of our lov's are slow. I've noticed that these lov's are pulling all the records. Is that normal forms behavior? Mind you, that the queries inside these lov's are fast but the lov's are loading all records all at once which is contributing to the slowness of the lov to appear on the screen.
But at the same time, I observed that some lov's don't do this. Like say if the whole record set contains 1000 records, the lov would only pull the first 100 rows. It's only when you scroll down the that it will pull the rest of the record set. Just like a forms block. I would prefer my lov's to behave this way so that the lov would generate faster on the screen.
I would like your insights on this on how I can resolve this.
Thanks.