Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Improving Processing Speed (any tips?)
- Thread starter oldduffer
- Start date
Hi Old lad,
As far as I know, there is no "Formula" for improving performance. The definition of heavy SQL processing itself is not well defined yet.
It all depends on
-- The Resources available
-- The quality of the SQL code
-- The frequency
-- # simultaneous instances
-- and so on...
If you are looking for TIPS, try this
You may then choose a particular section of your interest.
But make sure, as you might already be aware of, tunning any parameter/code may result in performace-degrade on some other.
BTW, what kind of 'heavy SQL processing' you have. Is it like DW project pulling data from other servers and processing/formatting it before uploading?
Good Luck
RajD
As far as I know, there is no "Formula" for improving performance. The definition of heavy SQL processing itself is not well defined yet.
It all depends on
-- The Resources available
-- The quality of the SQL code
-- The frequency
-- # simultaneous instances
-- and so on...
If you are looking for TIPS, try this
You may then choose a particular section of your interest.
But make sure, as you might already be aware of, tunning any parameter/code may result in performace-degrade on some other.
BTW, what kind of 'heavy SQL processing' you have. Is it like DW project pulling data from other servers and processing/formatting it before uploading?
Good Luck
RajD
- Status
Similar threads
- Locked
- Question
- Locked
- Question