Does anyone have performance tips for someone who is writing a jdbc app from scratch? I'm open to any jdbc versions and I'd prefer if the postgresql server isn't beta. Should I avoid prepared statements? What if I want to get the sequence ID for an insert, do I need two roundtrips, one for getting the sequence ID, another for the insert? Don't most databases allow you to do one insert to get the sequence ID, implementing it with one round trip?
Thanks for any help/tips.
Changed your e-mail? Keep your contacts! Use this free e-mail change of address service from Return Path. Register now!