NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: pcrafton on March 05, 2008, 06:55:30 AM

Title: using stored procedures with web server
Post by: pcrafton on March 05, 2008, 06:55:30 AM

Using 4.29 and M$ SQL Server 2005...

has anyone used stored procedures for data retrieval/processing with the Web Server?

I want to speed things up a bit and let the SQL backend do most of the work, instead of bogging down the webserver.

Paul

Title: Re: using stored procedures with web server
Post by: Bruce on March 06, 2008, 01:07:03 AM

Hi Paul,

I know precious little about stored procedures in MsSql. So my first question would be: How would you use them normally in Clarion? The answer to that is likely to be the same answer from the NetTalk perspective.

My guess at your answer is that you create a IMDD table, use the Stored Procedure to populate it, and go from there.

Cheers
Bruce