Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Network Speed Test
Message
From
18/04/2011 17:33:32
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01507569
Message ID:
01507763
Views:
78
Cyrus,

>>The Dropdown is the means to type in customer's Account number in an Order Entry form to locate the customer from the entire database. There is noway to limit that by indexing methods.

If the customer table is a dbf, the faster sites are probably benefiting from VFP's local caching which is the reason you see OK performance. This particular benefit of VFP sometimes isn't appreciated/remembered by people using C/S backends. Perhaps you can figure out whether/why VFP caching is different on the slow machine?

Even if you can, and realizing that this may be an established app that can be difficult to change: people here routinely pull customers from databases with millions of records with instantaneous performance. So I think people are disagreeing that the combo is the only way to achieve it. IMHO using the whole table every time will always create a risk of terrible performance, even in VFP, whereas a targeted query can continue to work fine across a 56K dial-up connection against any size database.

Would it be possible to add code to perform a query based on user entry to populate the combo with a handful of possible candidates rather than the whole customer base? That should work quickly every time.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform