ASP Time Out Issues Contd.

[Laphan]

Hi Guys

Can I just ask if ASP/ADO/OLEDB/Tab-delimited performance can be improved if
I have a separate ASP page for each tab-delimited file rather than just 1
ASP page that parses each.

Can I also ask if tab-delimited files perform worse than CSV files.

For those who haven't read previous posts, I had a site that was working
great with this method and then all of a sudden I keep getting horrendous
time out problems. See the site at http://www.bardwells.co.uk.

The method of the client editing their lists in Excel, saving them to
tab-delims and then uploading them was working great and I don't want to
change it to be honest. I know the way is to have a DB, but this was
working fine until either my multiple ASP pages to 1 page change or
FastHosts recent 'upgrade' caused this problem.

Any feedback you would be very much appreciated.

Regards


Laphan

 

[Ray at]

Changing to a DB will be inevitable. Do it.

I don't see that you'd notice any difference between tab-delimited and
comma-delimited since a tab is just another character. If the users are
uploading multiple files, perhaps they can just upload one at a time.

But, seriously, you're just putting off what you will have to do eventually.
Maybe when you start losing clients, you'll bite the bullet and convert your
site. I'm not saying this to be cocky or anything. It's all for the good
of your site.

Ray at home