Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2002-03-07 : 21:55:22
|
| I have a SP that is run 100,000's of times per day. It is a simple select statement that grabs about 15 columns all on the same table, most of these values are datatype INT. Awhile back I switched it from doing 15 joins onto other tables such as "tblstates" that for example contained 2 columns (id, statename) .. I now just run a SELECT CASE in the ASP code on that number and display the appropriate info.Anybody have any thoughts/comments on this? It seemed to work faster but I haven't done any official tests nor will I be able to for quite some time.ThanksMIke |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-07 : 22:57:46
|
| Now that you ask, I'd also be interested to hear comments about both these options vs user defined functions.....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2002-03-27 : 23:30:41
|
any body ??  |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-27 : 23:37:17
|
| Not really a lot to say Mike. If you say it's running faster with ASP we can not really disagree. There may be ways to speed up your sql code, but I can't really guess how.If the ASP seems to run faster, stick with it.Damian |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2002-03-28 : 02:30:35
|
| ok that is what I will do... 1 small thing tho, I didnt have my database indexed when I compared to the JOINS .. :) .. I'm sticking to this way for awhile regardless I just finished putting all the select cases into COM..thanks ,mike |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-28 : 02:38:37
|
| mike can you post both your Asp and Sp code ?-------------------------------------------------------------- |
|
|
|
|
|
|
joins vs select case