jtarabay
Posts: 13
|
| Posted: 11/17/2006, 5:42 AM |
|
I created a multiple table report. 4 tables using 2 or 3 fields from each one to be specific. When I upload it to my test IIS server which is running on the same network as my MSSQL server and try to access it, it times out. I change the timeout to 900 seconds and it still never finishes and pretty much crashes the IIS server. If I do the same report using on one table, it works just fine. Anyone have any advice? Thanks...
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 11/17/2006, 9:26 AM |
|
No advice, because you give not enough info.
From your post the only thing I can figure is that running on the server your SQL is wrong or table definitions differ.
Another problem could be that on test there are fewer rows in the table, while the server has a lot mor rows, time-out could then happen.
But I am not on MSSSQL/IIS.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 11/24/2006, 9:25 PM |
|
Turn on SQL Profiler and see what is going on on the backend.
Without seeing your code it is difficult to help.
I had a similar situation where I had a select box whose data source at one
client site had 50K records. This is something we had not planned for.
The query ran quickly, but the time it took to render the page resulted in a
timeout.
Are you having a connection timeout or a page timeout?
"jtarabay" <jtarabay@forum.codecharge> wrote in message
news:6455dbc4d8dfcf@news.codecharge.com...
>I created a multiple table report. 4 tables using 2 or 3 fields from each
>one
> to be specific. When I upload it to my test IIS server which is running
> on the
> same network as my MSSQL server and try to access it, it times out. I
> change
> the timeout to 900 seconds and it still never finishes and pretty much
> crashes
> the IIS server. If I do the same report using on one table, it works just
> fine. Anyone have any advice? Thanks...
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Hasibullah
|
| Posted: 11/27/2006, 11:18 PM |
|
I install code chargi creat one web site using the MSQL server but when i am runing the page it is not working i cant see the pages in IE or in IIS either when i am using the Sample Project i cant see the ASP file Result i chooese one sample project when i run for test and i click live page it is not working is there any setting for the first time using code charg i install but it is not workin if any one can help please help me .
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/27/2006, 11:58 PM |
|
Hi Hasibullah,
This topic is about a different problem.
Can you please create a new forum topic and describe the problem.
Thank you
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
