fiogf49gjkf0d 1. LAN or WEB Client???
2. ADMIN is one of the users used in the comparison?
3. Always set the 'on opening client' group to something with a small return of data.....keep it tight and fast. If it's All Accounts and retrieving xxx,000 records all bets are off even with Virtual Server Side Cursors (VSSC).
4. User's always take longer than ADMIN.....User queries have to use Team Ownership (Record Level Security) through the SLX OLE DB Provider when retrieving records...which is 4 to 10 times slower than an ADMIN retrieve.....throw in Field Level Security (FLS) and all bets on speed are off. User queries are on a one row per SQL Transacation basis...even when the team ownership is Everyone ReadWrite. Believe it or SQL Profiler it and start crying.
5. SLX Profiler is absolutely invaluable in showing what's taking so long.....and anytime you see something like:
retrieved 168 records
retrieved 168 records
retrieved 168 records
you can bet that the form needs to be redesigned as it is refreshing the data grid multiple (and NEEDLESS) times. |