Waspman
Posts: 948
|
| Posted: 04/20/2006, 2:45 AM |
|
Is it a database type / server issue that determines how many records can be exported?
with Access on a dedicated server I struggle with anything over 2000.
Any help would be apppreciated.
Ta
_________________
http://www.waspmedia.co.uk |
 |
 |
wkempees
Posts: 1679
|
| Posted: 04/20/2006, 3:34 AM |
|
What do you mean by "exported"?
And is the "struggle" meaning a time issue or non-completion?
_________________
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
|
|
|
|
Waspman
Posts: 948
|
| Posted: 04/20/2006, 6:13 AM |
|
Exported - to save as an Excel file
Struggle - Script times out
_________________
http://www.waspmedia.co.uk |
|
|
|
eiden
Posts: 34
|
| Posted: 04/23/2006, 3:55 PM |
|
You can increase the default timeout of the ASP script.
For example, if you want 100 seconds:
Server.ScriptTimeout = 100
|
|
|
|
Waspman
Posts: 948
|
| Posted: 04/24/2006, 12:08 AM |
|
Thanks.
I tried all that many times, at one point set to 1440
Still doesn't do it.
_________________
http://www.waspmedia.co.uk |
|
|
|
eiden
Posts: 34
|
| Posted: 04/24/2006, 2:26 AM |
|
If the script times out, I would write it as a *.vbs script file, and execute it with windows script host..
|
|
|
|
Waspman
Posts: 948
|
| Posted: 04/24/2006, 2:35 AM |
|
Sounds beyond my capabilities
_________________
http://www.waspmedia.co.uk |
|
|
|
Waspman
Posts: 948
|
| Posted: 04/24/2006, 2:35 AM |
|
Sounds beyond my capabilities
_________________
http://www.waspmedia.co.uk |
|
|
|
Waspman
Posts: 948
|
| Posted: 04/24/2006, 8:20 AM |
|
I show the records on the screen first then there's a button to export to Excel which passes the same parameters.
Do you think SQL would work faster and be able to cope with larger numbers?
_________________
http://www.waspmedia.co.uk |
|
|
|
donsafar
Posts: 90
|
| Posted: 04/25/2006, 10:17 AM |
|
There are 3 levels of timeout you need to be concerned with. 1. Script timeout, 2.IIS timeout, 3. Sql Server timeout. Google for answers and you'll get the solution to your timeout problems.
_________________
Don Safar
|
|
|
|
Waspman
Posts: 948
|
| Posted: 04/25/2006, 10:38 AM |
|
Thanks,
I've done the Script and the IIS, can't be SQL cos I'm using access.
Could it be the Host?
_________________
http://www.waspmedia.co.uk |
|
|
|
