What is OLTP in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
On Line Transaction Processing.

Anything that you do later, like running a report, is
'off line', and typically 'batch'. Anything that you
do while the data is being created is 'on line'. A
transaction is anything that changes data in the database.

So OLTP means updating the database (and typically
returning a result), in real time, while it actually
happens.

Banks do On Line Processing. Internet sites do On Line
Processing.

A database system may be optimised for OLTP, or On Line
Reporting, or Off Line Reporting, or Batch Transaction
Processing. If your application is small, you may not
care if the database system is optimised for anything.

(david)
 
Processing. If your application is small, you may not
care if the database system is optimised for anything.

Yeah.. that's me! I don't worry if it is optimized - I just consider myself
lucky if I don't find a new problem every time I use it! <g>

Fred Boer (Having found a significant bug once a day for three days in a row
now... sigh...)
 
Back
Top