Need Advice on Linux vs. Windows for a Database-Driven Web Application

From: Curious Pete (virtualcowboy2004-curiouspete_at_yahoo.com)
Date: 01/19/05 

Date: 18 Jan 2005 17:55:55 -0800

Hi there. I am hoping that someone here can offer me some database
advice.

I work at a small company that makes frozen products that are sold in
supermarkets. We recently hired sales reps in several cities in the US
and Canada to maintain our displays in stores and to take orders from
those stores. Each rep visits 12 stores a day and take a digital photo
of our display at each store. Then they go home, write up an email to
us about the situation at each store, attach the digital photos to the
emails, and send it to us. Then they write emails to the local
distributors containing their orders for the day and send them,
cc'ing us.

The system is working well, except as we add more and more sales reps,
the flow of information into the Head Office is becoming a raging
torrent, and frankly we can't keep up with it. So, we came up with
the great idea to automate the entire process via a database-driven web
application. The idea is that the sales reps should be able to log into
a site, enter a user name and password, then enter and upload their
report, photos and orders for the day, which would thereafter be stored
in a database that we could access from the Head Office.

There is a lot of data to input: Store Name, Street Address, City, Zip,
Store Contact etc. etc., plus all our various distributors and
individual products. We figure that the system should be robust enough
to handle at least fifty sales reps covering a total of 3,750 stores.

We sent RFPs to several software companies and received several bids
back. Okay, here comes the question part: Roughly half the bidders want
to use Linux/Apache/MySQL/PHP while the other half wants to use
Microsoft/IIS/MS SQLServer/.NET. (We are currently running a Microsoft
server in the office, but if it was cheap enough, I suppose we could
add another server running LINUX.)

My question is: Which solution is "better", and, from my (user's)
point of view, do I even care? (The software-building costs are about
the same for both types of system.)

I am looking for a robust system that will last our company for several
years, that can be added to as we think of more bells and whistles, and
that will need minimum maintenance.
Thank you in advance!

Curious Pete

Relevant Pages

  • Re: Need Advice on Linux vs. Windows for a Database-Driven Web Application
    ... We recently hired sales reps in several cities in the US ... > and Canada to maintain our displays in stores and to take orders from ... > in a database that we could access from the Head Office. ... such email processing is very similar to spam filtering. ...
    (comp.os.linux.development.apps)
  • Need Advice on Linux vs. Windows for a Database-Driven Web Application
    ... I work at a small company that makes frozen products that are sold in ... We recently hired sales reps in several cities in the US ... and Canada to maintain our displays in stores and to take orders from ... stored in a database that we could access from the Head Office. ...
    (comp.os.linux.development.system)
  • Re: Need Advice on Linux vs. Windows for a Database-Driven Web Application
    ... We recently hired sales reps in several cities in the US ... > and Canada to maintain our displays in stores and to take orders from ... > in a database that we could access from the Head Office. ... No question - the Linux based one. ...
    (comp.programming)
  • Re: Max Exchage DB size in SBS
    ... private) rather than total. ... The stores grow as necessary to house their content, ... the database will grow by 100mb. ... becomes "slack" in the database. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Multi phase processing
    ... I writing a perl/mysql backend to a website, ... number of pages of input, then, at the end, stores all the info on the ... all of which is taken from some data tables on the database. ... approach completely and use a decent session module that lets you ...
    (comp.lang.perl.misc)