[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
database locking for item increment/decrement?
****** message to minivend-users from Larry Leszczynski <larryl@furph.com> ******
Hi All -
> [data
> table=inventory
> column=qty
> row="[item-code]"
> value="-[item-quantity]"
> increment=1
> ]
Is there any locking on the database when this kind of increment/decrement
is done? Hope so, maybe Mike can verify...
Someone had posted a message that they keep item quantities in the
products file, rather than a separate inventory file, for sake of
simplicity. Assuming the database is locked while increment/decrement
happens, wouldn't that affect the performance seen by other users trying
to browse the products file at the same time? Or is it possible to
read-only while another process has a write lock?
Just wondering,
Larry Leszczynski
larryl@furph.com
--
furph, Inc. WWW/Unix/Windows Solutions 734-513-7763 (voice)
info@furph.com http://www.furph.com 734-513-7759 (FAX)
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
