October 26, 2006 at 6:58 am
i have 3 tables in my database(sqlserver) for each table 3,00,000 records and 3 tables are inter-related.when i try to retrieve the records,the server says timed out.
can anybody send me how could i query it in sql
October 26, 2006 at 7:32 am
The server won't timeout on its own. Are you sure it's not the connection or object command that times out?? or the web server if asp(X) code?
October 26, 2006 at 9:42 am
Im assuming the query works in Query Analyser and if so, how long does it take to return the result set?
October 30, 2006 at 5:41 am
Could you give us the DDL (including all the indexes) as well as your query to see where your problem is located
Bye
Gabor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply