Best practice question re performance

Question

Post reply

Best practice question re performance

Colin Bruce

SSC Enthusiast

Points: 152
More actions
May 8, 2007 at 2:50 am

#177798

Is it better to have a lookup table with a datetime column and 3 or 4 int columns, or have a stored procedure that builds data from linked tables on-the-fly?
Which would be better in terms of performance, or does it come down to preference?

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

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

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

Can you be a little more specific about what you're trying?

In general, for performance question, my first answer is 'try both and see which is better'

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

Colin Bruce SSC Enthusiast Points: 152 More actions · Answer 2

Thanks for your response, I typed a full explanation which got eaten by a browser crash.

The upshot was I will try both!

tnk SSCrazy Points: 2613 More actions · Answer 3

I don't know your exact problem, but I just wanted to say, I've never encountered any relational database problem that absolutely had to be solved by a stored procedure that generates lookup table data on the fly. I've only been doing this stuff for a few years now but it's been my experience that there is almost always a simpler solution than something like that.

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

Please post some details when you get a chance. I'm interested in seeing what you're doing.

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