Re: My Web Application Support 1 Million concurrent user??



RE:
<< What are the elements of skillful design?? This may [be] a silly
question.. >>

Skillful design almost always comes down to keeping things simple and
sticking with the fundamentals. I have worked extensively with beginners
over the years, and have been hired many times to help solve problems
created by beginner programmers. The common theme I see amongst their
terrible products is that they make things overly complex or somehow get
away from well known and well documented fundamentals. Database design is by
far the easiest place to go wrong with respect to good design. Thanks in
large part to MS Access (which makes it very easy to go wrong), many
beginners think of a database as being a spread***. They never take the
time to learn relational database design and the "normal forms" of which the
first 3, at a minimum, should be adhered to. With the database completely
screwed up (because they essentially implement a "spread*** design" rather
than a normalized design) the very foundation of the system they are
building is completely unstable, lending itself to massive data integrity
problems and runtime performance problems. Then proper application layering
doesn't happen (again, because MS Access encourages beginners to bind the UI
directly to the underlying table structure).

I could go on and on. But those two issues (database design and application
layering) are lost on most beginners. Learn the fundamentals. Stay with
them. Wandering off into the "creative realm" without first nailing down the
fundamentals and adhering to well-documented standards and best practices
will almost guarantee (IMHO) that you're making a major mistake and that you
are going to screw up performance, data integrity, extensibility, etc.

-"Bob"


.