6/19/2026 8:26:37 AM
|
| |
| 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!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Slow Lookups at a site
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
|
|
|
|
Re: Slow Lookups at a site
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? |
|
|
|
Re: Slow Lookups at a site
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 |
|
|
|
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!
|
|
|
|
|
|
|
|