Gil Hale wrote: > <snipped> > > All that said, the difference in performance on the P75 machines was > noticeable in terms of a few seconds (like 3 seconds instead of 1 second for > some processes). I never saw multi-user access result in a > seconds-become-minutes impact. You aren't running under Vista are you <g>. > How punchy is the File Server (CPU, RAM, LAN i/o speed). Are you running on > a switched LAN connection, or a hub? Are you sharing that switch/hub with a > data intense device (Exchange Server)? How big are the tables in terms of > records? Are you doing direct table hits, or using parameterized (and > optimized) views? >
Piggybacking on Gil's comments---grab data only when you need it. Avoid senseless queries pulling data over the wire that you don't need. _______________________________________________ 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.
