Keena,

Do you mean the program that they are using is written in JAVA? I think
it all depends on what kind of query the program is issuing. I would
look at those queries and check whether right kind of indexes are there
for the tables.

John

-----Original Message-----
From: Ferguson, Keena [mailto:[Email Address Removed]
Sent: Tuesday, June 17, 2003 7:41 AM
To: LazyDBA.com Discussion
Subject: SQL and JAVA

All,

Does anyone know of any issues with JAVA code running on SQL Server 2K
... I
have AD folks complaining about response time in their programs ... They
are
selecting and updating on the primary key, stats have been run, and the
table only contains 800+ thousand rows ... I can select * the whole
table in
Query Analyzer in less than 2 minutes ...

Thanks,

Keena Ferguson

Sr. Database Administrator
Comdata Corporation
[Email Address Removed]
615-371-3483
www.comdata.com


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page