I'm running a php script from the command line against SQL server 2005 using the MS driver for PHP and getting time outs. The query takes about 2 minutes from SQL Server Management Studio and returns > 300,000 rows. There are multiple queries in the script and for each one I do a sqlsrv_connect(), execute the query and then sqlsrv_free_...
Our site works fine for 90% of the day, then during our peak hours when traffic is about twice as heavy as normal, everything slows down to a crawl. Page load times that are normally 1 second take 30 seconds. Checking our error logs, it looks like it may be a connection pool issue. We have 3 web servers connected to 1 sql server db. ...
I recently discovered that a sql query that was running fine earlier is now timing out after 60 seconds and throwing an error. The query is slow but runs as part of a nightly job so that's not a problem in itself (so please don't suggest I optimize it). I'm able to reproduce the error consistently by running "select SLEEP(120);" from P...
Hi, We are 2 WCF service A) hosted on IIS and B) hosted as Windows service. We are using WSHttp binding When i am calling B from A i am receiving the below error To prevent the service from aborting idle sessions prematurely increase the Receive timeout on the service endpoint's binding any idea??? ...
How to dynamically change the timeout of the cycle plugin here is my attempt : page here is the code : <script type="text/javascript"> $(function() { $('#delais').val(3); $('#plus').click(function(){$('#delais').val(parseInt($("#delais").val()) + 1)}); $('#moins').click(function(){$('#delais').val(parseInt($("#delais")....
Hi, I would like to know what are the best practices, if you have a quite long lasting process that ends up with a transaction timeout and which should definitely be possible to rollback if any exception is thrown within? Imagine that all along the application set timeout duration is quite enough but for such a specific one it is not ...
Brief question What command can I use to make my DataSet refresh it's connection to the SQL Server before I go on to work with the DataSet object? I'm working with C# in .Net 2.0 Much longer version of the same question with specifics I have a database application that is often left running for several hours between manually instigat...
Hi, I'm trying to use a jQuery statement inside a setTimeout function, but I don't get it to work. I tried a lot of variants, like this one (I'm using 'this' because the setTimeout is inside an each function, and the selector is cached/stored in an object, thus the $selector): setTimeout("" + this.$selector + ".val('" + this.savVal + "...
I am wondering when I read a response stream and a timeout occurs, can I retry the read? Or do I have to make a new request? The server that I am downloading from does not support resuming, so I need to protect against timeouts. ...
Hi there, i seem to be getting a lot of this in my Linq 2 SQL System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. There is really no reason for it, its a simple query that returns 1 record. I was thinking about opening my datacontext w...
Inside the read FD_SET I have several sockets: the main socket listening for new connections accepted sockets listening for incoming data. I set the timeout for 30 seconds and called select(). I quickly noticed the behavior is different for each: When a new client connects on the listening port, it returns immediately from blocking...
hi, i hope you guys know about webim a.k.a mibew messenger. I know only java, jsp and no idea about php except for some basics. Anyways, i ran this app in my apache2.2 local server. Everything works superb! But if i change my db to a virtual machine and give its address in the config.php (previously i had used localhost), in the visitors...
From the JavaDoc for setSoTimeout Enable/disable SO_TIMEOUT with the specified timeout, in milliseconds. With this option set to a non-zero timeout, a read() call on the InputStream associated with this Socket will block for only this amount of time. If the timeout expires, a java.net.SocketTimeoutException is raised,...
So lets say there's a server process that takes way too long. The client complains that it "times out." Correct me if I'm wrong, but this particular timeout could have to do with apache's timeout setting, but not necessarily. I believe this to be the case because when testing the page in question we couldn't get it to time out reliably ...
Hi Alls, Im using the SocketServer module for a tcp server. I'm experiencing some issue here with the recv() function, because the incoming packets always have a different size, so if i specify recv(1024) (i tried with bigger value, and smaller), it get stock after 2 or 3 requests because the packet length will be smaller (i think), and...
If I run a stored proc using the SqlCommand and the SqlCommand times out does the StoredProc continue to execute or does it get force to quit when the SqlCommand disconnects? ...
Hi. In the method from Connection, how much timeout should I give it? :S I have no idea what a normal timeout would be, how much time should it take? :) I dont want isValid() to return false if it could return true if it had gotten more time, but also I don't want it to slow down the whole program and give me "freezes". If I set 0, d...
When the Oracle 10 databases are up and running fine, OCILogon2() will connect immediately. When the databases are turned off or inaccessible due to network issues - it will fail immediately. However when our DBAs go into emergency maintenance and block incomming connections, it can take 5 to 10 minutes to timeout. This is problematic fo...
Hello, I am trying to implement a function using boost asio udpSocket, that waits until data is ready to be read, or waits until a timeout expires. using asyc_read and a async_wait, I can do something similar, but I have to read the data. I would like to do the same without reading the data This would allow a much easier use of the ud...
When ever I use the following code the pool result always returns a timeout, is there something logically incorrect I am doing? from multiprocessing import Pool, Process, cpu_count def add(num): return num+1 def add_wrap(num): new_num = ppool.apply_async(add, [num]) print new_num.get(timeout=3) ppool = Pool(processes=cpu_count(...