Sequel Overflow or Timeout?
From: Gjones (anonymous_at_discussions.microsoft.com)
Date: 05/06/04
- Next message: Daniel P.: "Re: stored procedure"
- Previous message: mike: "Re: stored procedure"
- Next in thread: John Bell: "Re: Sequel Overflow or Timeout?"
- Reply: John Bell: "Re: Sequel Overflow or Timeout?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 May 2004 13:29:06 -0700
I'm creating individual user tables dynamically that have
different field names and values. Then users access the
dynamic tables with a web interface.
One of the ASP pages has several nested queries that
itterate through the dynamic table. Users can choose to
query all ATTRIBUTES for thier table or just some. When
the application runs on my laptop it works every time no
matter how many ATTRIBUTES for processing are selected.
On the web server that has the exact code, tables and data
content if a user select too many ATTRIBUTES the results
never return. The processor drops off when it finished
but SEQUEL appears to not ever pass the results or
the "I'm finished" message back to IIS.
The output typically comes back as Excel but it also fails
if I make it HTML. I have done a test making the results
write out to a text file and it finished writing to the
file but the browser still times out.
I have the Session time out set to 60 minutes on the web
server and the processor goes back to zero in about 13
minutes.
Have you ever seen this before? Got any ideas?
Thanks,
Greg Jones
Gjones@Acnielsen.com
- Next message: Daniel P.: "Re: stored procedure"
- Previous message: mike: "Re: stored procedure"
- Next in thread: John Bell: "Re: Sequel Overflow or Timeout?"
- Reply: John Bell: "Re: Sequel Overflow or Timeout?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|