|
| |
|
|
crosscreek
Posts: 107
Joined: 2/5/2008
Status: offline
 |
stored procedure questions - 3/21/2008 21:04:20
I am trying to make my pages a little faster with stored procedures.
I've been reading about them & have the idea on how to make them & execute them I do have a couple of questions that I haven't been able to find the answer to.
Where to you write the Create stored procedure codess?
.....Do you create a seperate page & "include" the page where you need it (with include file) OR do you create the SP in the connection page? I am using an <!-- #include file="connections.asp" --> (or does it really matter as long as you include the file)
Can you write multiple stored procedures on one page? Is there a way to keep them seperate?
Thanks for everyones help...
|
|
|
|
ou812
Posts: 1539
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: stored procedure questions - 3/21/2008 21:33:16
Normally, stored procedures are written with whatever but are stored along with the database, to be ran by the database, and you call them when needed. But maybe I'm not understanding? What DB are you using?
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
|
|
crosscreek
Posts: 107
Joined: 2/5/2008
Status: offline
|
RE: stored procedure questions - 3/21/2008 21:42:32
I'm using mysql & mysql is through my hosting company
I may not be the one understanding.
| |
|
|
|
ou812
Posts: 1539
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: stored procedure questions - 3/21/2008 21:56:54
I haven't worked with the MySQL engine for quite a while, but I think you should just be able to write your stored procedure while in SQL mode on while on your host (unless it has some handy stored procedure button). Of course, you can write them ahead of time with notepad, or whatever, and then just copy/paste them into the SQL window on the host. Then as you need the SP, you call it as needed in your ASP code. And you can write as many as needed while on your host in SQL mode, and then call whatever whenever in your ASP code.
If you've got down how to write them and call them, you should be good to go. Not sure if that helps.
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
) 