Does the same thing happen if you run the query directly against the database (Query Analyzer)? Are you sure there are only 2500 records?
On 12/28/06, Dunn, Eric <[EMAIL PROTECTED]> wrote:
** Morning, I am having an odd issue. I implemented some new functionality today on my production server. The implementation contains several new forms and some updates to existing forms. The issue is on one of the existing forms several new fields have been added. Some of these fields are no required and do not have data in them. The database holds about 2500 records. The issue is if I run a simple query i.e. = status = active. It takes several minutes and causes the client to stop responding. Once the record set comes back, if I attempt to look at another record the stop responding this happens again. This does not happen on the development server and only happens on the "enhanced" schema. There is nothing in the error logs. I am running ARSystem 5.01.02 on a Windows 2000 server with SQL Server 2000. Any ideas on how or what might the issue be? *Eric W. Dunn* Programmer Analyst III - Remedy/Collaboration McLeod USA, Inc. - Network Engineering 8665 New Trails Dr. The Woodlands, TX 77381 (281)465-1265 (281)465-1951 *fax* *NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail.* __20060125_______________________This posting was submitted with HTML in it___
-- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
