using stored procedures with web server

[pcrafton]

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

[Bruce]

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