I just recoded a client’s system to make 2 requests to the database in place of 16,000.
This would count as a triumph of programming skill if it wasn’t for the fact that I’m the idiot who coded it to make 15,998 unnecessary requests in the first place…
D’ Oh !
It wasn’t quite so bad when originally written – only about 10 queries. But then the database sort of got big… 😀
Yep, they do have a habit of growing exponentially…I was once asked to do an growth potential analysis of one of our DB’s and to recommend some mitigration strategies…”eliminating the user community” didnt go down all that well 🙂