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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-04-20 : 09:47:53
|
Grazi writes "Hello!!I'm a begginer in all these stuff and I'm facing a dilema!I have a page (in ASP) which displays looots of information from many different tables. There is a main table, but, then, there are really lots of parent / child / Many to many connecting table.So far, I have around 5 recordsets in this page!Now, I'd like to know, what would be the best way of doing this? Doing one stored procedures with lots of queries on it?orDoing lots of different stored procedures for each query? orJust doing the queries on the page like I'm doing now?Any help would be much appreciated! Thank you! Grazi" |
|
CFGURU
Starting Member
6 Posts |
Posted - 2004-04-21 : 11:22:13
|
I'd probably write one SP for each result-set you need. Doing this will allow you to call those SP's on other pages that need the same data. If you were to group each query into one larger SP, you then eliminate this kind of flexibility. It all depends on what you're doing really. It could be wise to write only one SP if the queries you're writing are not going to be used in other pages.| www.trajiklyhip.com| Certified Macromedia FlashMX Developer| Team Macromedia for ColdFusion |
|
|
|
|
|