Stack Overflow
Stack Overflow

Questions tagged [query-timeout]

26 questions
0
votes
0 answers

Intermittent SQL Server Query Timeout

I have a SQL query that intermittently times out for some clients/users – but never for others. The query is submitted by connecting to an application server which then launches a SQL connection under an application service id. Some days everything…
Isin2000
  • 1
  • 1
0
votes
1 answer

Configure db query timeout for quarkus application

How to configure database query timeout? I went through the documentation for all available configurations options, but seems like there is no configuration for db query timeout. I have tried multiple combinations for configuration but those…
Abhishek Pratap Singh
  • 613
  • 3
  • 11
  • 18
0
votes
1 answer

Select where in () with many items \ IDs is timing out

I have a node JS script which handles large amount of records and compare it to an existing records in database (SQL Server) The NodeJS dynamically construct the query. It fetches data from external source and compare it to my database. Example: I…
Gil Allen
  • 1,169
  • 14
  • 24
0
votes
2 answers

MongoDB Timeout Query

I'm trying to figure out if there's a way to apply a query timeout in the script file of MongoDB to prevent slow/idle/hanging requests. I am referring https://docs.mongodb.com/manual/reference/method/cursor.maxTimeMS/#examples documentation. Now I…
Shanmukh Borole
  • 69
  • 2
  • 9
0
votes
1 answer

How to set or disable the Query Timeout with a C++'s CDatabase ODBC connection to a SQL Server database

I need to have a query run by some code. Running the query in MSSMS takes a minute and a half (not too shabby for over 4M rows). In code I open the connection with CDatabase *base = new CDatabase () ; base->OpenEx ("Driver={SQL…
user9658871
0
votes
1 answer

Is there any way to set jdbc query timeout globally in java project

Can we set Query timeout globally (i.e. in DataSource configure, spring application properties file or somewhere).As i have to write everywhere in my project in which Statement / PreparedStatement used. I have seen only two ways to set query…
Dhaval Shah
  • 23
  • 1
  • 5
0
votes
1 answer

How does setting EF (6) Command Timeout, interact with a streamed Query

I have an app with a handful of heavy-duty queries, in amongst the normal CRUD operations. I was just fixing an issue that a bunch of code calls were changing the timeout of the context and not resetting it. I want to leave the normal low timeout…
Brondahl
  • 7,402
  • 5
  • 45
  • 74
0
votes
0 answers

Select query from Oracle database is not getting timeout - Connected through ADODB interop

I am using ADODB interop DLL Version :6.0.0.0 to connect any type of database. CommandTimeout is 3 seconds Opening the recordset with command object with timeout of 3 seconds. With Oracle database with huge data, when I enter select query, itdoes…
user2678302
  • 9
  • 3
0
votes
1 answer

Hibernate timeout does not work in postgresql 10

persistence.xml: …
Ricardo Costa
  • 41
  • 4
0
votes
0 answers

cassandra aggregate query timeout

I am new to Cassandra and running User-defined Aggregate on a Cassandra 3-node cluster on local machine. Issue is that when i am running this aggregate on a smaller data set, result is fine and as expected. But when data is too large, query fails…
Vibhav Singh Rohilla
  • 760
  • 1
  • 5
  • 17
0
votes
0 answers

Mysql large table stucks on update or delete query

In Mysql one table is of 10GB and if i select data it will run very fast but as soon as I do any insert or delete operation it stucks on select operation after that. How to resolve this issue that if I do any update or delete it stucks on select…
pramukh kulshrestha
  • 34
  • 2
1
2