
Taking an existing system and making it run more efficiently--that's database optimization. It's accomplished through reviewing how queries are built, adding indexing, de-duplicating, cleaning data (did you know that those errant keystrokes were actually saved?) and turning on and observing performance measures.
Q. What kind of projects need optimization?
A. Some:
|
when the db has grown over time |
when it's slower than it used to be |
|
when the db hangs |
when reports that took minutes take hours |
|
when you're adding new functionality |
...and more |
Q. Can I get references?
A. Of course. Email me and I'll send you a list.
Q. Can you handle large scale projects?
A. I have worked in Western Massachusetts since the mid-80's. I maintain contacts with many of the programmers and systems professionals in the Pioneer Valley.
Q. What if I don't see my database on your list?
A. Contact me anyway. We may be able to figure it out; if not, I'm likely to know whom to call.
Q. I don't see my question in this list.
A. Email me.