[quoted text, click to view]

OLEDB. ODBC is being deprecated, partly because it is just a
performance-sucking layer.

[quoted text, click to view]

It will perform better in relation to just about everything, IMHO. Even
better would be SQL Server 2000, MSDE edition. Of course we can't really
say because there are too many other factors; the only way you'll know for
sure is if you test, in your environment, with your typical usage, behavior
and traffic levels.

A

[quoted text, click to view]
Could have made a great joke but out of respect for the newsgroup, I'm tying
my hands behind my

[quoted text, click to view]

Hi Guys

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.

We're not talking Marks & Sparks here, but they do get quite a few visitors.

Any help you can give would be appreciated.

Rgds

Laphan

Thanks for the lightening feedback guys

Rgds

Laphan

[quoted text, click to view]
Could have made a great joke but out of respect for the newsgroup, I'm tying
my hands behind my

[quoted text, click to view]