Server Timeouts with ASP/ADO/Text Files

[Laphan]

Hi Guys

I know this is a tall order, but I thought you would be the best bet.

I developed a simple ecommerce web site for a client so that they could
update their price lists in MS Excel, save them as tab-delimited files, they
upload them to a folder via FTP and then ASP/ADO kicks in to grab and
display the products.

Now this is no Amazon and their price lists are no bigger than 6KB each, but
when visitors are looking through the site they keep getting timeout errors,
even when on ADSL.

Now this was working fine, so I can only think that one of the following is
causing it:

1) I'm hosting the site on FastHosts and they have just upgraded to some
form of envisage Windows 2003 server system.

2) I used to have a html page for each price list, but when I had a mo I
decided to rid myself of these 70 odd html pages and create 1 ASP products
page, which would select the relevant tab-delimited price list when I pass
it in the JavaScript querystring data.

3) They are getting popular and the site can't cope.

I've contacted FastHosts support and all they said was that I could try to
use an OLEDB Jet 4 DSN-less connection rather than the ODBC Text Driver
DSN-less connection that I was using. Doesn't seem to have made a
difference though.

The web site is called [url]http://www.bardwells.co.uk[/url] and it is when you click
on the Product List link on the left hand side and then start to view the
products via the pop-up at the top right.

If you don't know what it is, could you at least go to the site and let me
know if you experience these problems as well.

Thanks

Laphan

PS: This method is perfect for my client and I don't want to go down the
Access/SQL Server route.

[Ray at]

Please don't multi-post. See asp.general and continue the thread in only
one group - probably this one actually.

Ray at work

"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:bfhd9m$p$2@titan.btinternet.com...

> Hi Guys
>
> I know this is a tall order, but I thought you would be the best bet.

[John Beschler]

That error is almost certainly due to your ASP script
timing out waiting for ADO to return it's data. Are you
using text files exclusively for the database? By that I
mean, you do not have a true database such as SQL or
access for the backend.

If that is the case, I suspect your problem lies in
waiting for ADO to read the text files. You might try
increasing the script timeout value, but that would be a
bandaid approach, since it seems like it already takes a
long time to timeout. You might try to simplify the text
files to make them smaller.

You should explore ways to elimnate those text based price
lists. A true database will usually perform better than
any kind of text based system.

>-----Original Message-----
>Hi Guys
>
>I know this is a tall order, but I thought you would be

the best bet.

>
>I developed a simple ecommerce web site for a client so

that they could

>update their price lists in MS Excel, save them as tab-

delimited files, they

>upload them to a folder via FTP and then ASP/ADO kicks in

to grab and

>display the products.
>
>Now this is no Amazon and their price lists are no bigger

than 6KB each, but

>when visitors are looking through the site they keep

getting timeout errors,

>even when on ADSL.
>
>Now this was working fine, so I can only think that one

of the following is

>causing it:
>
>1) I'm hosting the site on FastHosts and they have just

upgraded to some

>form of envisage Windows 2003 server system.
>
>2) I used to have a html page for each price list, but

when I had a mo I

>decided to rid myself of these 70 odd html pages and

create 1 ASP products

>page, which would select the relevant tab-delimited price

list when I pass

>it in the JavaScript querystring data.
>
>3) They are getting popular and the site can't cope.
>
>I've contacted FastHosts support and all they said was

that I could try to

>use an OLEDB Jet 4 DSN-less connection rather than the

ODBC Text Driver

>DSN-less connection that I was using. Doesn't seem to

have made a

>difference though.
>
>The web site is called [url]http://www.bardwells.co.uk[/url] and it

is when you click

>on the Product List link on the left hand side and then

start to view the

>products via the pop-up at the top right.
>
>If you don't know what it is, could you at least go to

the site and let me

>know if you experience these problems as well.
>
>Thanks
>
>Laphan
>
>PS: This method is perfect for my client and I don't want

to go down the

>Access/SQL Server route.
>
>
>
>
>
>
>.
>

[Laphan]

Hi Guys

Even though I got a nice email from FastHosts saying their network guys had
fixed the problem its still terrible.

Anybody had any better results?

Rgds

Laphan



Mark Ryder <mark.ryder@bluespark.co.uk> wrote in message
news:f117e836.0307220345.3bde526f@posting.google.c om...
Laphan
Don't blame yourself, we have been having timeout errors on quite a
few of our asp sites since Fasthosts 'upgraded'.



"Laphan" <news@FrozenMoles.co.uk> wrote in message
news:<bfhd9n$p$3@titan.btinternet.com>...

> Hi Guys
>
> I know this is a tall order, but I thought you would be the best bet.
>
> I developed a simple ecommerce web site for a client so that they could
> update their price lists in MS Excel, save them as tab-delimited files,

they

> upload them to a folder via FTP and then ASP/ADO kicks in to grab and
> display the products.
>
> Now this is no Amazon and their price lists are no bigger than 6KB each,

but

> when visitors are looking through the site they keep getting timeout

errors,

> even when on ADSL.
>
> Now this was working fine, so I can only think that one of the following

is

> causing it:
>
> 1) I'm hosting the site on FastHosts and they have just upgraded to some
> form of envisage Windows 2003 server system.
>
> 2) I used to have a html page for each price list, but when I had a mo I
> decided to rid myself of these 70 odd html pages and create 1 ASP products
> page, which would select the relevant tab-delimited price list when I pass
> it in the JavaScript querystring data.
>
> 3) They are getting popular and the site can't cope.
>
> I've contacted FastHosts support and all they said was that I could try to
> use an OLEDB Jet 4 DSN-less connection rather than the ODBC Text Driver
> DSN-less connection that I was using. Doesn't seem to have made a
> difference though.
>
> The web site is called [url]http://www.bardwells.co.uk[/url] and it is when you click
> on the Product List link on the left hand side and then start to view the
> products via the pop-up at the top right.
>
> If you don't know what it is, could you at least go to the site and let me
> know if you experience these problems as well.
>
> Thanks
>
> Laphan
>
> PS: This method is perfect for my client and I don't want to go down the
> Access/SQL Server route.

[BigLarry]

Hi,

The problem is purely fasthosts. I've had an account with them for 3
weeks now and haven't had a straight answer from them. Basically they
don't have a clue.

There servers are grossly overloaded and under specced, hence you get
time-outs all the time.

By the way they don't refund either, at one stage they said I needed
to go mySQL which they charged me 58quid for!!! They won't refund a
penny of it and the site STILL timesout (OK, it may work ok for the
odd half hour)

They are selling a service which they can't provide, simple as. It's
criminal.

They will try to blame it on your site script, so make a simple asp
page with one call to the database, that way when you ring tech
support and they try to blame it on your script you can show them that
page.

Simply put, fasthosts couldn't host anything, useless.







"John Beschler" <giles@geewhiz.com> wrote in message news:<0e0c01c35074$1d4c1660$a601280a@phx.gbl>...

> That error is almost certainly due to your ASP script
> timing out waiting for ADO to return it's data. Are you
> using text files exclusively for the database? By that I
> mean, you do not have a true database such as SQL or
> access for the backend.
>
> If that is the case, I suspect your problem lies in
> waiting for ADO to read the text files. You might try
> increasing the script timeout value, but that would be a
> bandaid approach, since it seems like it already takes a
> long time to timeout. You might try to simplify the text
> files to make them smaller.
>
> You should explore ways to elimnate those text based price
> lists. A true database will usually perform better than
> any kind of text based system.
>
>
>
>
>

> >-----Original Message-----
> >Hi Guys
> >
> >I know this is a tall order, but I thought you would be

> the best bet.

> >
> >I developed a simple ecommerce web site for a client so

> that they could

> >update their price lists in MS Excel, save them as tab-

> delimited files, they

> >upload them to a folder via FTP and then ASP/ADO kicks in

> to grab and

> >display the products.
> >
> >Now this is no Amazon and their price lists are no bigger

> than 6KB each, but

> >when visitors are looking through the site they keep

> getting timeout errors,

> >even when on ADSL.
> >
> >Now this was working fine, so I can only think that one

> of the following is

> >causing it:
> >
> >1) I'm hosting the site on FastHosts and they have just

> upgraded to some

> >form of envisage Windows 2003 server system.
> >
> >2) I used to have a html page for each price list, but

> when I had a mo I

> >decided to rid myself of these 70 odd html pages and

> create 1 ASP products

> >page, which would select the relevant tab-delimited price

> list when I pass

> >it in the JavaScript querystring data.
> >
> >3) They are getting popular and the site can't cope.
> >
> >I've contacted FastHosts support and all they said was

> that I could try to

> >use an OLEDB Jet 4 DSN-less connection rather than the

> ODBC Text Driver

> >DSN-less connection that I was using. Doesn't seem to

> have made a

> >difference though.
> >
> >The web site is called [url]http://www.bardwells.co.uk[/url] and it

> is when you click

> >on the Product List link on the left hand side and then

> start to view the

> >products via the pop-up at the top right.
> >
> >If you don't know what it is, could you at least go to

> the site and let me

> >know if you experience these problems as well.
> >
> >Thanks
> >
> >Laphan
> >
> >PS: This method is perfect for my client and I don't want

> to go down the

> >Access/SQL Server route.
> >
> >
> >
> >
> >
> >
> >.
> >