Posted by Doug on 09/25/81 11:38

Hello Mr. Pateel,

Did you work at Sears in 1999? I worked with a gentleman there in that
timeframe that had a similar name, but it might have been Pattel.

In any case, you MUST be doing a web site for a really high volume,
high profile customer. At 2000 sql calls a minute, I'd think about
batching your data, and going about it differently. Think of the old
VTAM days where you asked for a screen full of data components, show it
to the user, and wait for their input. So instead of a sql call for
every field, do a sql call to a stored procedure equivalent on the 390
for each screen. Stored procedures can gather data from a variety of
tables. Return all the data that MIGHT be needed for the screen, and
let the Web app throw away what it doesn't need.

If you truly have 2000 different users hitting 2000 web pages a minute,
call microsoft directly through your sales rep. They would be GLAD to
help you tune that in.

[Back to original message]