Optimistic doesn’t try to lock the data until it
\ngoes to do the update. \u00a0Pessimistic locks the data
\nas soon as it is changed and doesn’t release the
\nlock until the data is updated on disk.<\/p>\n
Optimistic does not monopolize the data and can
\nmake a multiuser app work smoother, but pessimistic
\nwill guarantee that the user will never see the
\n“Another user has updated that record already”
\nmessage.<\/p>\n
You mention “client\/server” which leads me to
\nbelieve you are using a back-end that is not
\na VFP database? \u00a0If so, there are some
\ndifferent considerations regarding impact on
\nthe performance of database access. \u00a0I have
\nyet to do a client\/server app in VFP, so I
\nwill yield the floor to someone who has…<\/p>\n","protected":false},"excerpt":{"rendered":"
Optimistic doesn’t try to lock the data until it goes to do the update. \u00a0Pessimistic locks the data as soon as it is changed and doesn’t release the lock until the data is updated on disk. Optimistic does not monopolize the data and can make a multiuser app work smoother, but pessimistic will guarantee that […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-23970","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-6eC","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23970"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23970\/revisions"}],"predecessor-version":[{"id":23971,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23970\/revisions\/23971"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}