Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append blank VS insert SQL
Message
From
25/03/2005 08:26:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00998018
Message ID:
00999118
Views:
24
>>>Hi.
>>>I believe i read in the Help that when buffering is on it is adviseable to use Append Blank, Replace construction. Is it still true, or Insert is OK across the board?
>>
>>Can't find that in help - and with buffering you are actually delaying the write until tableupdate(), so the difference between the two actually vanishes. VFP only has more work to do with its buffers meanwhile, if you append/replace.
>
>VFP8 Help.
>You can look for General Table and Index Optimization Hints
>"If record or table buffering is not enabled, use Insert-SQL instead of Append Blank, Replace ..."

It's written in VFP7 documentation as:

"If record or table buffering is not enabled, use INSERT - SQL instead of APPEND BLANK followed by REPLACE, particularly with an indexed table in a multiuser environment, because indexes only need to be updated once."

I think it's saying what Dragan already said. It's not advising "append blank", does it?

Anyway real concern is not speed in a multiuser environment. Append Blank doesn't lock the record. IOW you could append blank and I could replace:)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform