>The Atom processor is of the Bay Trail type. Yes, 32Gb is the entire storage. I opened the Mini PC, which by the way has a form factor similar to typical routers, and saw that the storage looks like a USB drive embedded on its motherboard.
>
My money is on Flash RAM then. Try to enhance via storage card, USB Stick if something is available and fast enough.

>Regarding order printing before saving, since I myself developed this, I made it a point that both header and child records are SAVED (wrapped in a transaction) before I print the order. Seriously, this what really confounds me. How could the child rows 'escape' the transaction being save in the server?

Since I have no idea how you coded it, how you connect to/access MySQL what error handling you employ that is very had to guesss.
For paranoids or people under the watch of tax auditors it makes sometimes sense to move some "biz intelligence" server side, like flagging a certain field dependant on correct save via stored procs.
And having extensive logging available during testing can be a big help...