Jun. 3rd, 2007

andrewducker: (Exciting)
Waaaay back at the dawn of time, in 1991, I was responsible for a rewrite of a dBase database used by a bunch of hospitals to keep track of treatment in the neonatal intensive care units. By judicious use of caching data in memory, very careful construction of filter statements on the fly, etc. I was able to bring down some calculations from running overnight (and taking about 9 hours to run) to only taking 20 minutes. Which was something I was insanely proud of at the time.

Ten years later I rewrote it all again, this time in Visual Foxpro. And due to the database software being much better and the hardware being an order of magnitude faster, I was able to use simple SQL and have the queries run in real time (well, up to 10 seconds for a big one). It was such a relief to throw away the code I'd hand-crafted, and a joy to get the answers back quickly. And I don't even work with databases any more - but part of me misses having to carefully fine-tune SQL to eke out every last efficiency.

Originally a response to this post on [livejournal.com profile] theferrett's journal.

Language

Jun. 3rd, 2007 11:28 am
andrewducker: (Find X)
If you have any interest in language then you'll love the two videos here. The first is a simple bit of thought about language - nothing terribly new, but nicely done. The second is Stephen Fry and Hugh Laurie doing a sketch about language that strikes me as too high-brow for 99% of TV nowadays (mind you, the same probably goes for back then too).

August 2025

S M T W T F S
      1 2
3 4 5 6 7 8 9
10 11 12 1314 15 16
17 18 19 20 21 22 23
24 25 26 27 28 2930
31      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Aug. 30th, 2025 08:57 pm
Powered by Dreamwidth Studios