myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Timeout Expired - Query Options · View
crouillon
Posted: Wednesday, July 23, 2008 8:45:00 PM
Rank: Newbie
Groups: Member

Joined: 7/23/2008
Posts: 2
Points: 0
Hi,

I get the:

Error -2147217871
Timeout expired,


when execute a query, there is a option of up the value of Timeout?, or What can I do? some idea?

Regards
elian
Posted: Thursday, July 24, 2008 9:01:17 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Which version of myLittleAdmin are you using?
What kind of query is it?
crouillon
Posted: Friday, July 25, 2008 6:27:27 PM
Rank: Newbie
Groups: Member

Joined: 7/23/2008
Posts: 2
Points: 0
About the version of myLittleAdmin:

Product : myLittleAdmin For SQL Server and MSDE
Version : 2.7
Release : 123



Is a query that call to others functiones, is of kind:

select Jug_Codigo, Jug_CodClub,case CHARINDEX ( ' ', Jug_Nombre, 1 )
when 0 then Jug_APaterno +case Jug_AMaterno when '' then '' else ' '+left(Jug_AMaterno,1)+'.' end + ', ' + Jug_Nombre
else Jug_APaterno +case Jug_AMaterno when '' then '' else ' '+left(Jug_AMaterno,1)+'.' end + ', ' + left(Jug_Nombre , CHARINDEX ( ' ', Jug_Nombre, 1 )+1) + '.'
end as Nombres,
case dbo.fIndHCP3(Jug_Codigo, getDate())
when 99.90 then NULL
else dbo.fIndHCP3(Jug_Codigo, getDate())
end as Indice,
Penalizado = case
when Jug_FechaPenalizadoF > GETDATE() then '**'
else ''
end , Jug_Sexo As Sexo, '1' as Empadronado,
dbo.fhcpAzul4(Jug_CodClub, Jug_Codigo, GETDATE(),Jug_Sexo) as Azul,
dbo.fhcpBlanco4(Jug_CodClub, Jug_Codigo, GETDATE(),Jug_Sexo) as Blanco,
dbo.fhcpDorado4(Jug_CodClub, Jug_Codigo, GETDATE(),Jug_Sexo) as Dorado,
dbo.fhcpRojo4(Jug_CodClub, Jug_Codigo, GETDATE(),Jug_Sexo) as Rojo
into #tempnac
from Jugador
where Jug_Status<>'0'

drop table #tempnac
elian
Posted: Monday, July 28, 2008 8:38:15 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
It looks like this query takes too long to be fully executed and the SQL Server returns a time-out error. In a webhosting environment (shared SQL Server) the time-out value is often set to 45sec by the webhosting company.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.