Book a Demo

Author Topic: Timeout on SQL search query  (Read 3813 times)

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Timeout on SQL search query
« on: October 18, 2018, 07:11:17 pm »
We are using an SQL Server backend and one of our export searches returning a timeout after a while.
Does anyone know if you can somehow increase the timeout?
When running the same query directly in SQL Server Management Studio we don't get a timeout.

I know I can probably improve the performance of the query by rewriting it, but that is not what I'm looking for.
Optimizing the query would take a non-trivial amount of time, and since it's something we run only once every couple of months, we don't care if it takes 10 minutes to execute.

The query is a bit too long to post here (34.000 characters, 508 lines, the forum only allows 20.000 characters per post)

Thanks

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Timeout on SQL search query
« Reply #1 on: October 18, 2018, 07:42:17 pm »
You better ask that the guys at SO, I guess.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Timeout on SQL search query
« Reply #2 on: October 18, 2018, 08:38:46 pm »
I searched a bit online on the problem, and it seems like the query timeout is set by the application code.
If that is the case then only the Sparx developers will be able to solve the problem.

Hoping to get a reponse from someone at Sparx.

Geert