Hi Experts,

In my n-tier apps, for transactions like Invoices, I usually pull ALL invoices header records to a grid for the user to view and search. Then, there are buttons for CRUD functionality in the same form. Alas, this obviously has performance issues if records reach well beyond 100,000 over the internet (this seems to work reasonably fast enough over LAN) as this would take quite a while. Heck, I wouldn't sit around and wait that long either. =)

I would like to ask what should be the proper or industry practice to such forms. Kindly share how you guys do it.

Thanks In Advance. Love live the Fox!

Dennis