Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practices for N-Tier Forms
Message
From
14/10/2010 16:28:47
John Baird
Coatesville, Pennsylvania, United States
 
 
To
14/10/2010 16:13:53
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01485511
Message ID:
01485512
Views:
133
>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

Use a search form to limit options or use demand paging on the grid.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform