Scripts, Large Rowsets, SPs And Timeouts...
I have an ASP page which pulls in, say, 800 records from a table containing ~ 1 million rows (and growing) - I use a command object and this calls a stored procedure, passing 5 parameters to the stored procedure from the querystring.
Now, if I run the stored proc from Query Analyzer, it takes between 25 and 40 seconds.
If I run it from the ASP page, if it takes LESS than 30 secs to generate then I get the output fine, but as soon as the 30 seconds elapse without anything being returned, I get a "Timeout expired" error.
I have taken the following action to eradicate, but all to no avail.
1.) Added Server.ScriptTimeout = 1000 into the page itself
2.) Upped the Script timeout figure in IIS for the application the report is within.
3.) Added a "Connect timeout=1000" line into my connectionstring (I was clutching at straws here...)
None of these alterations made any difference, so i'm a bit miffed.
View Replies
ADVERTISEMENT
I'm doing a query on a webproxy log, which is a pretty large table. I'm only doing a query on a single days worth, but could be upwards of 250000 records.
Originally I got a timeout error saying to increase the time using Server.ScriptTimeout so I put Server.ScriptTimeout = "900" at the top of my script. This didn't seem to help. Now I got this error: a.. Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/suntest.asp, line 39
This time it didn't mention what type of timeout I'm experiencing, at least, not that I can see. Code:
View Replies
View Related
I have a couple of pre-built ASP scripts running on my site. One is a mailing list application and the other is subscription/user management app. The two aren't related - they were programmed by different people and use separate dbs.
I have a problem where the user has to hit the login button twice in order to succesfully login. On the mailing list app, as soon as I try to login the first time, I get an error that says "Your session has timed out".
Then once I re-login, everything is fine. The subscription app has the same problem in addition to timimg out very quickly if the user is inactive for even a couple minutes.
Do you think this is a problem with the way the web server is setup for session timeouts, or is there some code in each of these ASP scripts that need to be fixed?
View Replies
View Related
is it possiable to have for example 2 sessions and that one of them will have 40 min timeout and the other session 60 min?
View Replies
View Related
I connect to a databae with my ASP code to run special reports and every now and then the DB server seperate from the server I have the ASP on is really being used and I get SQL timeouts after 60 seconds.
to connect I use a DSN. Is there a way to set the timeout to 360seconds instead of 60 when using a DSN?
View Replies
View Related
We are using ASP.NET on IIS5 to process requests
in a database.
How can one make choices in the .aspx based on
if a user has or hasn't changed a field? Is it possible
to control the ASP.NET environment by use of
some client side scripting ( ?changes=yes to URL)
or is there a way to tell in .aspx which Label elements
has changed?
Only solution i can think of currently is to query the
DB and then do an field by field comparision. Is that
the best way?
View Replies
View Related
I've been using text files for Tab-Delimited/ADO/ASP sites so that users can
update and display their products lists through my system with relative
ease.
Only problem is that for the last few months or so, this system has been
generating loads of timeouts. ISP has said that I should be looking to
upgrade my system, as it is the mechanics of it that are creaking under the
strain. My queries are:
a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less?
b) If I convert the system to use 1 Access DB rather than 50-odd
tab-delimited text files will this REALLY perform better in relation to
timeouts?
To give you some idea of the problems, the site can viewed by going to
www.bardwells.co.uk and clicking the Product List link.
I just can't understand it because the pages on the whole are very lean and
zippy (esp. ADSL), but its these exact same Broadband users who seem to have
more trouble with timeouts than dial-up ones.
View Replies
View Related
we have a page, that posts some search results to the server.
however it takes a while to execute and return to the client.
we added a server.timeout = 120 to the asp script. but it still timesout
is there a "USER FRIENDLY" way to redirect the client to another page, pending execution of the server results ???
View Replies
View Related
I'm beta testing a community membership site using ACCESS/asp on IIS5/windows server, shared with other sites. The performance is not consistent - sometimes OK, sometimes very slow and sometimes data access scripts time out (even when timeout set to 5 minutes) - sometimes the server recovers, and others a re-boot is necessary.
Can some one tell me if there are (or where I can find out if there are) performance issues involving 1. shared servers 2. incorrect data access set-up resulting in data access (e.g.concurrency/record locking, etc) problems 3. possible sloppy asp coding resulting un resource-hogging/non release, record locking etc.
View Replies
View Related
I want to have different user sessions timeout at different time intervals. How can we make this possible in ASP with and without using database tables.
View Replies
View Related
The following is the error keep getting while running web application.
Tools used: HTML, ASP, DLL's(written in Delphi).
Application Error: dllhost.exe - Application Error
---------------------------
The instruction at "0x00000000" referenced memory at "0x00000000". The
memory could not be "read".
Click on OK to terminate the program
View Replies
View Related
I am updating over 100 fields in 7 tables with SQL in VB 6.0. The values will mostly come from check boxes. Do I need a VB variable to hold each value for my SQL query?
Also, what is the syntax for skipping an optional field? Do I just skip it and use comma's? I will never know which values are checked off so I cannot write code that will only insert my true values.
View Replies
View Related
we are rebuilding a large website and we want to make sure it doens't lose it good ranking within the search engines. So we were thinking of using 301 to tell google where the pages have moved to.
The problem is I'm not really sure where to start to impliment something this. We have a website that has 26,200 indexed pages, so I need to come up with somekind of solution that would work across the board.
View Replies
View Related
I am a PHP programmer and trying to do a site in asp but one feature I can't figure out how to do in ASP is large variables.
In PHP it is
$fullpage = <<<EOT
THE ENTIRE PAGE OF HTML
EOT;
EOT can be anything it just uses that as a starting and ending point so I can have quotes, apostrophes, variables etc inside the page. Is there any way at all to do this in ASP? Code:
View Replies
View Related
I need to populate a select form input (combo box) with about 22,000 rows of data. This is taking an unacceptable amount of time to load. And this data is only going to grow in the future.
I'm using a stored procedure to get the data. Not sure if that's the most efficient. I'm using classic asp. I'm open to any suggestions because I'm not even sure where to look to get options.
View Replies
View Related
I am trying to upload large images ( around 4 mb) from the server to show on
the client. Currently I'm using an http handler to do it and breaking it
into chunks sending it 1 mb at a time. Sometimes I'm getting errors, like
the page won't load. Any solutions on how this is done right?
View Replies
View Related
I am trying to do some calculations on large numbers (ie
7,768,489,957,892,578,474,792,094 / 12,280) and no matter what I do it
doesn't get it quite right. Its always somewhere between 10 and and 5000 out
:(
I have a suspition is could be down to one of the number functions I am
using along the way but im not sure.
View Replies
View Related
I am using forms authentication to protect all content as described in the
kb article below.
http://support.microsoft.com/defaul...kb;en-us;893662
This works fine except for files that are larger than about 40 or 50mb at
which point the user gets a 404 error and the httperr log indicates
connection_dropped status.
This is a w2k3 server with SP1 and all security patches installed.
Has anyone seen this before? I have been reading various posts online but
none seem to fit this symptom. Also have tried tuning various meta-base
properties to no avail.
View Replies
View Related
It seems to me that I generally use two types of Functions:
Type #1-Ones that any page on my site might use
Type #2-Ones that only a single page would ever use
Logically, it seems that I should put the Type #1 functions in the GLOBAL.ASA file and the Type #2 functions in the pages that use them. I would like to, however, just go ahead and include ALL of my functions in the GLOBAL.ASA file.
Comments on this? Is this a good idea?
View Replies
View Related
when creating a webpage that must display a large result set, the page load time is unbearable. Unfortunately, there are a lot of records and they all need to be displayed, at once, on this one page.
To reduce file size, I have minimized the amount of HTML tags used to dislay these records. My only other idea is to write javascript matrix to hold the data, and then to use dom to create the page on the client side. Are there any tried and true ways of speeding up page loads?
View Replies
View Related
I am attempting to use the technique in KB 812406
(http://support.microsoft.com/?kbid=812406) to transfer
large files via Response.OutputStream.Write.
It works GREAT in in debug mode. But whenever I set
debug="false" in the web.config file clients get cutoff after about 1.5 minutes.
There is no error raised the client simple gets an incomplete file.I've tried playing around with various timeout settings in web.config and in IIS with no luck.
View Replies
View Related
I am currently developing a download centre for a hardware manufacturer which has alot of firmware and other software available to it's clients. Most of these are less than 10mb and with their internet connection I'm thinking a browser upload through the admin tools will be fine. However there are files on the current site of up to 100mb, how would be best to handle uploading these?
I was thinking maybe an ftp component would handle bigger files better than an normal http upload? Does anyone know of any components that allow some kind of background uploading so they can continue to use the admin for other tasks while this continues?
Or just any other suggestions full stop! Maybe I would need to come up with some way of taking them out of the system and loading a windows ftp with the correct directories etc.. predefined?
View Replies
View Related
I want to count number of data available depending upon the conditions in the large database the database table rows are approximately 3 lakhs and there are multiple table to be searched and records need to be displayed in ASP pages.
Kindly suggest the best scripting method as i am always getting error like "Script Time Out" Error in Active Server Pages (ASP)
please suggest how to avoid or in sql server i can create some pre defined script and just call from asp pages
View Replies
View Related
I've a large database that I am working with. The problem is right now I've so many sample data in the datbase all the testing data in it. I want to clear the database and reset the AutoNumber so that it starts at 1 and goes up by one.I know that its possible in Access and I've done it before, problem is the tables have relationship and lots of them.
the way I know to rest the AutoNumber require me to break the relationship but it will take very long time for me to rectreate them again and I might not get them same at the end.Is there a way to rest the AutoNumber without having to break the relationship?
View Replies
View Related
I am creating a dynamic website using ASP and an MS Access backend DB. I am a little confused with how to go about things and am now facing the following problem. I want a large volume of text to be loaded dynamically on my page but don't really understand how i should be storing this text as the database fields will only hold a max 255 chars.
Obviously this is not large enough to store all of the text i may need and so where should i be storing the text? The only idea i had was storing the text in an external text file to which i point to with the database field (i.e. database holds the path to the txt instead of the actual text itself).....is this possible? or more to the point is there a better way? How would this normally be accomplished?
View Replies
View Related
I hope we can upload only files with limited size through ASP scripts(<2MB). I need to write an ASP script that can serve up to 100MB of file uploading. I have written one script(with progress bar ;-)), as my hosting won't allow me any third party upload components. Is there any way we for ASP scripts to make larger file uploads?
View Replies
View Related
I have an asp page with a form, which has a lot of fields 30 to 40 .Is there an easier way to loop through all the fields submitted to the insert page or is the only way to do it using the standard, request.form for each field and then INSERT INTO Reports (ReportID, ReceivedDa very lengthy for this amount of fields. Perhaps there is a way of looping through some sort of collection ?
View Replies
View Related
I have a site that i upload files to that are no bigger than 100MB. we upload about once a day, and use FTP...... we would like to be able to do it from the site itself.
any idea where i can get a script? i cant register components with my
hosting company i dont think. i go thru godaddy.com
need a good free asp upload script. cant find any that work. Huge ASP Upload
doesnt even work on the demo page, let alone on my own page
View Replies
View Related
i'm getting the following error in my event log:
Event Type:Error
Event Source:Active Server Pages
Event Category:None
Event ID:5
Date:2007/03/09
Time:11:50:48 AM
User:N/A
Computer:ZEUS
Description:
Error: File /index.asp Data size too large. Size of data being sent
in the request is over the allowed limit..
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The problem is that when I get this error, all websites in IIS6 become completely unresponsive, and I have to run an iisreset.
View Replies
View Related
We are using Windows Server 2003 along with IIS 6. When trying to browse to an ASP page, the following error is returned:
Active Server Pages error 'ASP 0107'
Data size too large.
Size of data being sent in the request is over the allowed limit. the asp page in question is about 5 KB in size and we also increased the size of the AspBufferingLImit setting in Metabase.xml to over 16MB to no avail.
Similar ASP pages are all working, it is only this one, and there is nothing special or different about this one.
View Replies
View Related
If I use a form to pass data (say, for example, through a textbox) the data seems to be limited to somewhat smaller amounts. What should I do if I want to pass a large amount of data? For example a list of 200 items?
View Replies
View Related
principally I'm a photographer, and in the absence of any image galleries I could make sense of I created my own asp pages in Dreamweaver displaying images from a path stored in a database. These can then be paged through, all done using server behaviours in Dreamweaver. However, because I wanted to include some text next to my images, again a field in the database, I have to scale them down. I would like to give the user the option to see a larger version of the image on display, preferably in a pop-up window that is then closed by the user before they continue scrolling through the images....
View Replies
View Related
I am using couple of dropdowns on a form which pulls data from one of our
tables.
The data list is quite large (500+) and it takes users a lot of time to find
the correct item. Users are getting quite frustrated using the dropdowns as
they have to scroll for a long time.
View Replies
View Related
