[UFO Chicago] web development opinions needed.

[Jesse Becker]

--- Greg Groth <ggroth at gregs-garage.com> wrote:
> Because it has to cross reference the list of 1200-1500
> line items 
> against 500,000+ skus.  This situation only happens a
> couple times a 
> year, and although it takes a while to load, everyone is
> quite happy 
> with how it works.  Only issue I had to handle was
> playing with the web 
> server & database timeout settings.

Something to consider:  one size does not have to fit all.

If 99% of the usage will suffice with a webpage, great! 
Use that.  It's basically a presentation problem, where you
have a bunch of stuff in a database that needs to be show
to the users.  If you need other stuff--other "views" of
the data--then you could use a different application for
that.

It's really about seperating the data layer from the
manipulation data (which is just basic common sense
anyway).

You could use a standard webform for most use, and a
separate application (as Jordan suggested).  Alternately,
you could simply have a "big report" PHP script for that
once/twice a year occurance (make copious use of shared
code in this case).

Make it modular.  Don't limit how you present your data. 
Make it flexible.  Use the right tool for the right job--if
you need a complete inventory report, dump it in text (or
light formated HTML) suitable for printing.  If you need a
quick "lookup" ability for a parts, then make a quick
lookup function.  If you need something more complicated,
then do that.

Good luck!

--
Jesse Becker
GPG-fingerprint:  BD00 7AA4 4483 AFCC 82D0  2720 0083 0931 9A2B 06A2

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com