slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Slow Lookups at a site

Maria Amodei
Posts: 24

Slow Lookups at a site Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Oct 07 12:11 PM

I have a site I recently upgraded from 6.2 to 7.0.1. I completed the database upgrade on one of my machines with a backup of their production database, then created a backup that was restored on their server and we did the program upgrades in the early morning. All seemed to go smoothly except that there is a dramatic difference between performance on lookups on the database at their site, and the database on my machines. If I run a contact lookup (Lookup, Contacts, Email..., etc.) I have the results in under a second. At the customer site these lookups take 10-40 seconds. I rebuilt indexes on the database before I restored it there. They have been rebuilt again since this problem was noticed. They are SQL 2000. The upgrade has been in place for about 4 weeks now.

I've never done an upgrade before where I upgraded the production database off site. I can't think of what in the process could have caused a disparity so I'm guessing it is something in the environment? My next step is to get a fresh backup of the onsite database and set it up in my environment to see if something has changed.

Any ideas?

Maria Amodei

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Slow Lookups at a site Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Oct 07 8:48 PM

Maybe it's worth doing a full db optimisation on the restored db? Is everything else on the db looking OK, or is performance generally slower?

[Reply][Quote]

Maria Amodei
Posts: 24

Re: Slow Lookups at a site Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Oct 07 4:33 AM

I'll try that. I've got a copy of the db coming to me so I'm going to put it in my environment first to see if there is something in their environment that is slowing it down.

I would say it is generally slower, but most areas are subtle. The lookup delay is dramatic.

Maria

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/10/2025 1:11:02 AM