I'm using an MS Access Database on the back end. It's fully functional with forms, queries, vbmodules and such.
I keep seeing in responses to people's questions that they should use FUNCTIONS or STORED PROCEDURE's to speed up the data (One guy said 20 lines of vbScript in a page is too much). So someone explain to me pleezzz, using the following example. I have a search page in ASP that queries the database and returns the results in a new page. My search form has about 8 parameters. When processing the form, in my <% %> tags, I have this extensive code which parses out the variables, makes sure they where properly typed in, adds %'s, etc...and then opens the connection and grabs the data. (This code came originally from a form in access I had created to do the same thing). HOW in the name of ACCESS, do I move this code to something to make it run faster. Is an active-X DLL my only choice? I think I can pass the variables to dll component which will parse out my string. Or is there a simpler way?
Dazed and confused...again...
...but getting clearer every day thanks to this forum!
I keep seeing in responses to people's questions that they should use FUNCTIONS or STORED PROCEDURE's to speed up the data (One guy said 20 lines of vbScript in a page is too much). So someone explain to me pleezzz, using the following example. I have a search page in ASP that queries the database and returns the results in a new page. My search form has about 8 parameters. When processing the form, in my <% %> tags, I have this extensive code which parses out the variables, makes sure they where properly typed in, adds %'s, etc...and then opens the connection and grabs the data. (This code came originally from a form in access I had created to do the same thing). HOW in the name of ACCESS, do I move this code to something to make it run faster. Is an active-X DLL my only choice? I think I can pass the variables to dll component which will parse out my string. Or is there a simpler way?
Dazed and confused...again...
...but getting clearer every day thanks to this forum!