cflock - when to use it 4

[leadman]

Im not really sure when to use cflock and when not to. For instance, im using a custom tag that gets shippig prices from UPS. many users may be calling this tag at once - does that mean i need to use cflock?

 

[RedLion]

Hi Leadman,

For selecting data out your database with a SQL-query you don't have to lock anything to get the data. You can just read out of the table.

When you lock a record in a table, you say I'm at THIS moment editing this record, so knowone may edit the record from now on, until I release the lock, and I tell the database that other people may edit (I mean modify) the record, because I've made the modifications.

When a record is locked, everyone can read the data in the record, but the can't delete the record or make modifications to it. This can only be done by the one who has the lock.

BW the sql-statements delete, insert, update are taking care by themself with record locks.

I hope this cleared the definition lock,

Charl

 

[crafter]

The subject of locking has been extensively discussed on the CF-Talk forum. House of Fusion hosts CF-Talk at

http://www.houseoffusion.com.

If you check the mail archives you're sure to find many threads, some of which include links to further information.

 

[tleish]

The Depressed Press of Boston has extensively tested and written an easy to understand guide to Locking in CFML:

Locking in CFML guide

http://vboston.com/DepressedPress/Content/ColdFusion/Guides/Locking/Index.cfm

- tleish