NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Matthew51 on April 29, 2016, 03:18:22 PM

Title: A single slow view friezes the whole server
Post by: Matthew51 on April 29, 2016, 03:18:22 PM

I have a browse when sorted by the description field the SQL server takes a very long time to return the results of the view.  Now I'm already take steps to make the view faster, that's not my big concern.  My big concern is that while waiting the the view results the net talk server won't respond to any other requests.  Or at least not any where the p_web object is ask to access the database.  The requests just keep piling up until the SQL server finally returns it's results.

Net talk; 8.68 with SQL Server 2012 Express

Thanks

Matthew

Title: Re: A single slow view friezes the whole server
Post by: kevin plummer on May 01, 2016, 06:18:13 PM

are you using the MARS and Busyhandling driver strings on your SQL connection?

Title: Re: A single slow view friezes the whole server
Post by: Matthew51 on May 02, 2016, 11:21:52 AM

MARS yes, Busyhandling no.

The only busy option I see in the driver options dialog is loop on busy error, which is set to 20.

Title: Re: A single slow view friezes the whole server
Post by: kevin plummer on May 02, 2016, 02:54:28 PM

search busyhandling on this NG for more info.

Title: Re: A single slow view friezes the whole server
Post by: Bruce on May 03, 2016, 01:59:13 AM

see
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=403.0
for busyHandling and MARS setup.

But also note that if you have p_web.sqlsync = true (ie in your embed code, probably in webhandler) then this is also asking the server to serialize access to the Sql server, and thus would only allow one thread to access the sql server at a time.

cheers
Bruce

Title: Re: A single slow view friezes the whole server
Post by: Matthew51 on May 04, 2016, 10:34:32 AM

Adding /BUSYHANDLING=2 to the connect string fix it.  The slow view is still slow, but everyone else doesn't suffer for it.

Title: Re: A single slow view friezes the whole server
Post by: kevin plummer on May 05, 2016, 01:20:58 AM

check the filter on the slow view and make upper. make sure it's not doing the filtering locally.