Timed out with Views
-
running sql server 2000, I create a view and it runs fine on Query Analyzer bringing 18K records, when I try to run
the view meaning right click on view and return all rows I'm getting timed out...any ideas why??
thanks in advance
-
- Are there others trying to use the view or the underlying objects ?
- what's your isolation level (should be "read committed")
- Are there any exclusive locks on the underlying objects (ongoin update(s) or uncommitted transctions holding locks,...)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
read commited and it's a simple view joining 2 tables, but the tables are big like 30k records each
-
30K is not big these days
-If you can, post the view definition.
-Is the join being performed on indexed columns in both tables ?
- did you include a where clause (on an indexed column ?) ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply