I don't know if I'll be able to contribute much code, since I'm currently living in a .ec world. I've got a long history with sql though, and some dba experience, though. Maybe I could bounce some ideas off you all to try and get a handle on the issues that have been plaguing the 'free world' lately.
Sorry. Bad pun.
So. Before I start spamming the list with, "Have you tried X yet?" could someone let me know what the 5 biggest bottlenecks we run into is? Bandwidth limitations? Running out of CPU/Diskspace/log space/lock space/etc. etc.