none
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. RRS feed

  • Question

  • Hi Dear all,

    We have face a problem in c# and sql server database :

    in my dot net application use list and genric, in sql server 2000 we have two table
    one is URL and second SUBJECT table:
    URL Table structure :
        [URL_ID] [int] IDENTITY (1, 1) NOT NULL ,
        [URL] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
        CONSTRAINT  PRIMARY KEY  CLUSTERED
        (
            [URL_ID]
        )  ON [PRIMARY]


    SUBJECT Table structure :
    (
        [SUBJECT_ID] [int] IDENTITY (1, 1) NOT NULL ,
        [URL] [text] COLLATE Cyrillic_General_CI_AS NOT NULL ,
        CONSTRAINT PRIMARY KEY  CLUSTERED
        (
            [SUBJECT_ID])  ON [PRIMARY]
    )

    according to URL table in URL like 'http://www.acedisder.com/news' one reocrd

    and SUBJECT table URL
    http://www.acedisder.com/news/cpu/display/20070516063519.html,
    http://www.acedisder.com/news/cpu/display/20070516063519.php,
    http://www.acedisder.com/news/cpu/display/20070516063519.asp,
    http://www.acedisder.com/news/cpu/display/20070516063519.aspx etc.
    and this type  of 2lac reocrd with diffrent url but same as 'www.acedisder.com' . I select all record in subject table match with 'www.acedisder.com'.

    when search record in subject table

    but my appliction send error like
    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Please help me.

    thanks

    krish

    Friday, March 28, 2008 1:09 PM

All replies

  • Sounds like the query is taking too long to finish so you want to optimize your SQL table/query.

    • Proposed as answer by ashish.bisen Tuesday, November 30, 2010 6:56 AM
    Friday, March 28, 2008 6:26 PM