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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Procedures or Recordsets?

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?
or
Doing lots of different stored procedures for each query?
or
Just 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
Go to Top of Page
   

- Advertisement -