Ask a Question related to ASP Database, Design and Development.
-
Your Name Here #1
Inserting thousand of row (timeout?)
I'm importing thousands of rows into a sql server table using ASP on a
hosted machine.. I've got Server.ScriptTimeout set to 150000.
For some reason it quits at a 1000 rows or so.. is it possible that my web
host has set a script timeout on the server side that is overriding my
script settings?
TIA
Your Name Here Guest
-
#40750 [NEW]: fsockopen timeout parameter overwrites timeout for reading
From: andreas dot rieber at 2e-systems dot com Operating system: OpenSuse PHP version: 5.2.1 PHP Bug Type: Network related... -
WebService ignoring timeout properties? (Server was unable to process request. --> Timeout exired)
Hi! I have a webservice serving the latest orders from a webshop. The customer uses a forms app client to fetch these orders and push them into... -
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Gary Why not just change the connection timeout property? Your doing an update statement, which could take various amounts of time depending on... -
A picture is worth a thousand words
Hi everybody! How cool is Google Groups! As a brief introduction, my name is David and I am a university student from Melbourne, Australia. I... -
HELP!Step-by-step guide to inserting a TimeOut needed...
I have created a touchscreen game in Director MX and need to insert a time-out whereas if the game is left mid-play for a certain amount of time it... -
Bob Barrows #2 Re: Inserting thousand of row (timeout?)
Your Name Here wrote:
Probably.> I'm importing thousands of rows into a sql server table using ASP on a
> hosted machine.. I've got Server.ScriptTimeout set to 150000.
>
> For some reason it quits at a 1000 rows or so.. is it possible that
> my web host has set a script timeout on the server side that is
> overriding my script settings?
>
> TIA
This is a horrible (mis)use of web server resources. You should be using DTS
or bcp to bring those records into your database. With DTS, you can use an
ActiveX script task to do anything you are doing to the data in your asp
page. Since it's being done by the database server, your website users won't
have to wait for the slow asp-based import.
HTH,
Bob Barrows
Bob Barrows Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
