>The application I am writing may be upsized one day.
>Should I be using pessimistic or optimistic record locking
>Many Thanks

Mark,

Use optimistic as it will force you to address the issues related to it. There is no such thing as pessimistic when using a backend server.