I agree. Down the road it's going to be a nightmare especially if you have
server issues now. Sure for a month or two it would be ok but as that excel
file gets bigger and bigger you will run into trouble. Excel and Access are
just not meant for high traffic web sites. We don't charge people more to
use access but we make them keep the file below 20MB in size and we do not
allow Excel datasources. There is a small memory leak in Access that can
cause long term problems. I've never used Excel myself as a datasource but I
can only assume you would get the same results. IMHO, Access and Excel are
good for desktop apps only. I mean, I could eat of off a frisbee instead of
a plate and it would work but that doesn't mean I should do it.
Just my $0.02
Dan Phillips
CFXHosting.com
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:04 AM
To: CF-Talk
Subject: Re: Excel as a datasource .... ?
excel as a datasource would make maintainability, scalability, and
enhancements alot harder and in the long run cost more. Actually, at one
place I worked at we charged more if the client wanted to use Access over
SQLServer (I assume excel as a datasource would cost even more).
On Wed, 5 Sep 2001, Mike Kear wrote:
>
> I have a client who's complaining that the time spent generating a small
app
> using SQL is costing too much and wants to use excel spreadsheets instead.
>
> What's your experience using excel as a datasource?
>
> Just to clarify what the projects do, they don't write to the datasource,
> just look up and filter the data customising tables for the user's needs.
> The volumes aren't great - between a few hundred page views a month to
5000
> or so.
>
> IS there likely to be implications for the usage of RAM and resources on
the
> server? The System Admin is already complaining that he has to restart
the
> server too often and when the processor usage gets to 100% he panics and
> complains.
>
>
> Cheers,
> Mike Kear
> Windsor, NSW, Australia
> AFP WebWorks
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
