I have to agree with this -- my experience is that going low-end on the data
store always proves to be a bad decision in the long run.
One note on Excel that I haven't seen posted in this thread: I have seen
spreadsheets start to develop serious data corruption problems as they grow
beyond a certain size -- this may be dependent on system virtual memory
availability.
Robert Crooks
Technical Lead
Macromedia Educational Services
<http://www.allaire.com/conference/index.cfm>
-----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
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
