J
Joel Kolstad
Rich Grise said:I can one-up this one. I was on a temp job, doing "document coding", which
is pretty much data entry by a whole roomful of grunts. But, they found
out that I had computer skills, so they let me take a look at this
database software. It was called "Paradox", and the way it worked was
that all of the coders (the grunts at the PCs which are acting like
dumb terminals) were editing one huge database file by way of one
invocation of the program on "The Server".
Sounds famliar... I set up the occasional computer or piece of software at a
place that brokers fruits, and the custom software written for them was done
in Delphi, back in the days when a "fast" PC was something like a 100MHz
Pentium with 16MB of memory. The guy who wrote the software designed so that
every time you performed a query on the database, the contents of the entire
database were sucked over to the local PCs (10baseT Ethernet back then) where
the search was actually performed. :-(
I never re-wrote the thing (I don't have the skills nor am I particularly
interested in learning them), and happily PC performance has scaled much
faster than their database size, so these days performing searches only takes
some 5-10 seconds. Unfortunately, they now want to work from home with their
DSL or even dial-up connections, so it's the exact same problem all over
again. The currently proposed solution is using remote desktop software...
sheesh...
All of this because some guy didn't have the foresight to spend about 3
seconds thinking about scalability a decade back to reach a conclusion I think
most of the techno-nerds around here would have already come up with in high
school ...!
---Joel