Query Optimise

Question

Post reply

Query Optimise

rajiv.gupta

SSC Enthusiast

Points: 194
More actions
September 18, 2008 at 11:33 pm

#198253

I am using stored procedure and multiple views to show the record in Crystal reports but it is very slow. How can i fast It ?
It takes 1 min but i want it winthin 1 sec.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135382 More actions · Answer 1

Please read this little guideline to get the info you want asfast as you want.

Forum Etiquette: How to post data/code on a forum to get the best help

http://www.sqlservercentral.com/articles/Best+Practices/61537/

No problem for now.

The question you've asked is like:

'I have a car, what do I do to make it fast'

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

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 2

Check your tables index and index defragmentaion. If your fragmentation level 90% to 95% it will definately improve the performence.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

And please post in the appropriate forum next time.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004448 More actions · Answer 4

rajiv.gupta (9/18/2008)
I am using stored procedure and multiple views to show the record in Crystal reports but it is very slow. How can i fast It ?
It takes 1 min but i want it winthin 1 sec.

Sounds too obvious, but the answer is to rewrite the code to be faster using proper set based techniques and by paying very close attention to best practices.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)