HYT00 Timeout Expired (Error:3633)

[Haymanth]

Hi,

I keep getting that error message whenever I try to query all the records
in the database across 3 tables (I have about 250000 records). If I put a
whereclause in my sql statement then it's fine. I've tried increasing the
timeout period in my connection string. It is now at 1000, to no avail.

Any help you be appreciated, thanks

H

[Rune Bivrin]

Show us the SQL with and without the WHERE clause. My guess is you're
getting a cross join, which may well result in well over 1 billion rows,
which the where clause eliminates.

--
Rune Bivrin
- OOP since 1989
- SQL Server since 1990
- VB since 1991



"Haymanth" <haymanth@time.net.my> wrote in
news:3e13fcff$1@tnews.web.devx.com:

>
> Hi,
>
> I keep getting that error message whenever I try to query all the
> records
> in the database across 3 tables (I have about 250000 records). If I
> put a whereclause in my sql statement then it's fine. I've tried
> increasing the timeout period in my connection string. It is now at
> 1000, to no avail.
>
> Any help you be appreciated, thanks
>
> H
>

[Haymanth]

Hi,

Well if you want to see the sql, here it is:

SELECT dbo.DonorId.id AS donorFid,
dbo.IKSearchSource_VW_AllDonors.donorBBFid,
dbo.IKSearchSource_VW_AllDonors.donationFid,
dbo.DonorId.name AS tname, dbo.DonorId.newIC AS tnewic,
dbo.DonorId.oldIC AS toldic,
dbo.DonorId.passportNum AS tpassportnum,
dbo.IKSearchType_VW_BasicSearch.tBloodgroup,
dbo.IKSearchType_VW_BasicSearch.tRh,
dbo.IKSearchType_VW_BasicSearch.tCDE,
dbo.IKSearchType_VW_BasicSearch.tBloodpackNumber,
dbo.IKSearchType_VW_BasicSearch.LabRef,
dbo.IKSearchSource_VW_AllDonors.LastDonation,
dbo.IKSearchType_VW_BasicSearch.tDonationType,
dbo.IKSearchSource_VW_AllDonors.LastBloodbank
FROM dbo.IKSearchSource_VW_AllDonors LEFT OUTER JOIN
dbo.IKSearchType_VW_BasicSearch ON
dbo.IKSearchSource_VW_AllDonors.donationFid = dbo.IKSearchType_VW_BasicSearch.tDonationFid
RIGHT OUTER JOIN
dbo.DonorId ON
dbo.IKSearchSource_VW_AllDonors.donorFid = dbo.DonorId.id


This view relies on other views as well....I reckon you're right on this
one....thanks...

H

Rune Bivrin <rune@bivrin.com> wrote:
>Show us the SQL with and without the WHERE clause. My guess is you're
>getting a cross join, which may well result in well over 1 billion rows,

>which the where clause eliminates.
>
>--
>Rune Bivrin
> - OOP since 1989
> - SQL Server since 1990
> - VB since 1991
>
>
>
>"Haymanth" <haymanth@time.net.my> wrote in
>news:3e13fcff$1@tnews.web.devx.com:
>
>>
>> Hi,
>>
>> I keep getting that error message whenever I try to query all the
>> records
>> in the database across 3 tables (I have about 250000 records). If I
>> put a whereclause in my sql statement then it's fine. I've tried
>> increasing the timeout period in my connection string. It is now at
>> 1000, to no avail.
>>
>> Any help you be appreciated, thanks
>>
>> H
>>