slow BV's

m_e_wade

Active Member
slow BV\'s

System: Xe, NT Enterprise server, SP13, SQL Server

I'm working on a system that is slow when I try to access BV's. All environments seem to be affected. It doesn't matter whether I select P98305 in the menu or type BV in Fast Path.

On other systems with similar configurations typing BV and hitting ENTER gets instant results. Here a regular fat client takes about 5 seconds and the Citrix box takes 30 seconds before the selection window comes up. I'm aware of solutions like the OWDEVELOPER group. Added that and it didn't make any difference. I checked all logs (set it to debug mode) and I get no information showing what it might be trying to do that takes so long.

We're building new full packages and will deploy them tomorrow, but I'm looking for any suggestions that we might not have thought of yet.

Got any?

-MEW

Mike Wade
cd|group
5550 Triangle Parkway
Suite 200
Norcross, GA 30092
email: [email protected]
 
Re: slow BV\'s

Check the indexs on the F983051.

Look at the queries in the jdedebug.log. See if there is a delay between the launch of the SQL statement and the next line in the log. This shows a delay at the SQL server.

Take the query from the log and execute it through query anaylzer to get an execution plan. Check the plan to see if it's scanning or using an index.

Hope this helps.

Dave.

David D. Helsley, Inc.
[email protected]
Xe, Unix Sp16.1, Oracle/MSSql, TSE
 
Re: slow BV\'s

Hi Mike,

Did you check if that Client has the SQL SERVER ODBC connection using TCP/IP instead of Name Pipes which is the default. That would slowdown the response.


Adrian Valentim
Valmatrix Consulting Inc.
 
Re: slow BV\'s

Adrian,

I'm unclear on what you mean. Which is faster; named pipes or TCP/IP?

Thanks.

Dave.

David D. Helsley, Inc.
[email protected]
Xe, Unix Sp17.1, Oracle, TSE, Web, CustomWorks
Xe, W2K, Sp17.1, MSSql, TSE
 
Re: slow BV\'s

Sorry. TCP/IP is faster.

Adrian Valentim
Valmatrix Consulting Inc.
 
RE: slow BV\'s

I will hazard a guess that you are running McAffee on your Terminal
Server. Switch it off (at the service level) and observe the
performance improvement. It may also cause your OW logon to take
forever.
Regards,
Kieran Fitzgerald
 
Back
Top