Nothing unusual about these two profiles but the client loading takes about 1 minutes vs 5 - 10 seconds for other users.

Any idea what can be causing this delay?

thank you,

I would use SlxProfiler to see if there is anything happening behind in the database. You also might want to remove their cached configuration records from the VirtualFileSystem table.

- Mark

Thanks Mark,

VirtualFileSystem table is empty. Not sure about SLXProfiler. I do not see this tool installed anywhere. It is not listed on 'SalesLogix Admin Tools and Servers' install as well. Where can I find that?

thanks again,

Yogesh

It's always in c:\pf\saleslogix - just not on the menu - called slxprofiler.exe.

Found it. If anyone else is looking for this tool it is under /Program Files/Saleslogix directory where admin tools are installed.

Thanks Mark,

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.