I've recently started doing a little work with a client. They are opening about 20 tables but it was extremely slow. They were blaming VFP and the size of the tables and indexes. I wrote a small benchmarking utility to test opening the tables and doing a simple, business like query, and logging the results to a table. The test waited a period of time and repeated.
Bottom line: During the day, the test took 300 seconds. Bad. During the night, the same test took 5 seconds. Acceptable. Something was up with their network. They're getting their network gurus to take a look at it and the last I heard, they're getting new switches. Unfortunately, I didn't have access to their performance monitors to look at CPU, disk, and network loads. They're supposed to be getting back to me when they've got things straightened out. -Kevin CULLY Technologies, LLC > Eurico Chagas Filho wrote: >> Hi >> >> 1. How can I communicate to my client that the 40 some open files he sees >> are ok and are not clogging the network ? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
