For best performance and security use SPs for updates, inserts, deletes, etc.

Generally found ADO Client sider cursor for Connection cursor type to be fastest but should test both server side and client to see which holds up best.

I would use oridinal as long as you are using SPs or views and are sure they will not change but make notations as to what they reference, otherwise use name (a bit slower) but still has same effect if you alter SP or view or table being referenced.

Try to limit chatter where you can with SPs by using no recordsets execution when return is not needed or OUTPUT variable in place whne only few items return (like 1 int).

A lot is learned by building and rebuilding a project and asking questions. But there are always better ways to find to do many things just ask when you are curious or see a specific issue.