Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Nickel Contributor
Posts: 46
Registered: ‎03-29-2009
Accepted Solution

Scribe 7.0.1 running extremely slow on SLX V7.5.2

Upgraded to V7.5.2 from V7.5.1 on an installation that has Scribe running (V6.3.x) on a Windows Server 2003 64 bit server.  Once the SLX upgrade took place the Scribe DTSs would take 30-60 minutes to open.  Upgraded Scribe to V7.0.1 with the same results. (SLX and Scribe ran fine before the upgrade). 

 

Anyone else having an issue with SLX V7.5.2 and Scribe V7.0.1? 

 

The time to open is dependent upon the number of dblookups() in the DTS.  The Scribe Tracking indicates about 2 minutes for each dblookup() to run. 

 

We're suspecting something has changed with the SLX provider that may be an issue. 

 

What's been your experience/solution?

 

Thanks,

Bruce Pershke

PBDI

615-851-9497

Nickel Contributor
Posts: 46
Registered: ‎03-29-2009

Re: Scribe 7.0.1 running extremely slow on SLX V7.5.2

Believe we found the issue.  There isa customized field in the Address table (address_id) that had null values in over 200K records.  When the null was updated to a blank Scribe now runs as usual. 

 

What is it about V7.5.2 that it doesn't like null values?  This is exactly the same DTS that ran in V7.5.1 when there were null values in the address_id field.

 

Bruce Pershke

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Scribe 7.0.1 running extremely slow on SLX V7.5.2

Bruce, this is VERY interesting because the best practices way of handling "empty" (or invalid) values in foreign key fields is to "NULL" them out - not use blank(s).

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Nickel Contributor
Posts: 46
Registered: ‎03-29-2009

Re: Scribe 7.0.1 running extremely slow on SLX V7.5.2

We've ran across this in sever fields regarding a SLX Web Client project too.  When the value was null the Group wouldn't load or the form doesn't load (and or is very slow to open).  Once we blanked out the field it runs fine.

 

My concern is with customers entering data moving forward.  Will code be needed for the fields to make sure they are blank if a value isn't entered on a new record?  Just doesn't make sense to me that SLX or SQL would have a problem with nulls.

 

Bruce Pershke

Copper Elite Contributor
Posts: 153
Registered: ‎02-27-2010

Re: Scribe 7.0.1 running extremely slow on SLX V7.5.2

We had similar issues when upgrading from 6.2.2 to 7.2.2 so it isn't new with 7.5. Specifically, when Network Clients (and to a lesser degree Remote Clients) go into Opportunity Details View with the Notes/History Tab as default, they'd have to wait over a minute before theycould update. Our developer had to replace hundreds of thousands of Null Opportunityids in the History Table with Blanks to remedy the situation. We still have some other response issues in this and other areas we're trying to track down.

 

Thanks,

Larry Esposito