Is it safe t=o disable ""Safe Write for Database" in Preferences???=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listSafe Write DB:
Enabled by default. Sets the WebDNA engine to c=reate a temporary file when writing the contents of a database to disk. The t=emporary file contents are then moved to the original database file after th=e entire database is completely flushed to disk. This helps to eliminate cor=ruption of the original database file if there is an interruption during the= database write process.=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=If I disable this setting will all cha=nges be written to the db on the HD immediately, without that need for= a temporary file?I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a fe=w moments later. Like they never were altered in the first place....This site has been for over 10= years and the admin area has not been changed recently or much over that ti=me span...
=There is no co=nsistency to this issue.It happens (like today) but may not happen for days or weeks.I'm wondering if this "tempora=ry file" and the original database on disk are somehow under some circumstan=ces getting out of sync.=The db isn't that large, having 2,111 records,151 Fields and using 4,759K of= ram.I'm wondering if di=sabling "Safe Write" might be an option to try and prevent this in the futur=e.Very frustrating for t=he client.I can't seem to duplicate it myself,but I believe them when they s=ay it happens.I may have posted about this issue in the past as well.<=/div> I'm on Windows Server2008 using vers=..6.2I have nea=rly 1gb of unused ram on the server, plenty of hard drive space.... I've attached a screen capture of my Prefer=ences in case anything else can be tinkered with..To unsubscribe, E-mail to: archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us =---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list<webdna.jpg>.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77D--. Associated Messages, from the most recent to the oldest:
212--Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77DContent-Type: text/plain;charset=us-asciiContent-Transfer-Encoding: quoted-printableAre you seeing files next to your databases that are appended wit "-tmp"? I=f so, what are the most recent modification dates on them?D. Brooke Mobile> On Mar 15, 2016, at 3:15 PM, Rich Kwas
- Re: [WebDNA] "Safe Write for Database" setting.... (Terry Wilson
2016) - Re: [WebDNA] "Safe Write for Database" setting.... ("Terry Wilson"
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Kenneth Grome
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas
2016) - Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain
2016) wrote:>=20> Is it safe to disable ""Safe Write for Database" in Preferences???>=20> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D> Safe Write DB:> Enabled by default. Sets the WebDNA engine to create a temporary file when= writing the contents of a database to disk. The temporary file contents are= then moved to the original database file after the entire database is compl=etely flushed to disk. This helps to eliminate corruption of the original da=tabase file if there is an interruption during the database write process.> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D>=20> If I disable this setting will all changes be written to the db on the HD i=mmediately, without that need for a temporary file?>=20> I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a fe=w moments later. Like they never were altered in the first place....>=20> This site has been for over 10 years and the admin area has not been chang=ed recently or much over that time span...>=20> There is no consistency to this issue.> It happens (like today) but may not happen for days or weeks.>=20> I'm wondering if this "temporary file" and the original database on disk a=re somehow under some circumstances getting out of sync.>=20> The db isn't that large, having 2,111 records,151 Fields and using 4,759K o=f ram.>=20> I'm wondering if disabling "Safe Write" might be an option to try and prev=ent this in the future.>=20> Very frustrating for the client.I can't seem to duplicate it myself,but I b=elieve them when they say it happens.I may have posted about this issue in t=he past as well.>=20>=20> I'm on Windows Server2008 using vers.6.2> I have nearly 1gb of unused ram on the server, plenty of hard drive space.=....>=20>=20> I've attached a screen capture of my Preferences in case anything else can= be tinkered with.>=20>=20> --------------------------------------------------------- This message is s=ent to you because you are subscribed to the mailing list . To unsubscribe, E=-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us> --Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77DContent-Type: text/html;charset=utf-8Content-Transfer-Encoding: quoted-printable Are you seeing files next to your data=bases that are appended wit "-tmp"? If so, what are the most recent mo=dification dates on them?
D. Brooke MobileIs it safe t=o disable ""Safe Write for Database" in Preferences???=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listSafe Write DB:
Enabled by default. Sets the WebDNA engine to c=reate a temporary file when writing the contents of a database to disk. The t=emporary file contents are then moved to the original database file after th=e entire database is completely flushed to disk. This helps to eliminate cor=ruption of the original database file if there is an interruption during the= database write process.=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=If I disable this setting will all cha=nges be written to the db on the HD immediately, without that need for= a temporary file?I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a fe=w moments later. Like they never were altered in the first place....This site has been for over 10= years and the admin area has not been changed recently or much over that ti=me span...
=There is no co=nsistency to this issue.It happens (like today) but may not happen for days or weeks.I'm wondering if this "tempora=ry file" and the original database on disk are somehow under some circumstan=ces getting out of sync.=The db isn't that large, having 2,111 records,151 Fields and using 4,759K of= ram.I'm wondering if di=sabling "Safe Write" might be an option to try and prevent this in the futur=e.Very frustrating for t=he client.I can't seem to duplicate it myself,but I believe them when they s=ay it happens.I may have posted about this issue in the past as well.<=/div> I'm on Windows Server2008 using vers=..6.2I have nea=rly 1gb of unused ram on the server, plenty of hard drive space.... I've attached a screen capture of my Prefer=ences in case anything else can be tinkered with..To unsubscribe, E-mail to: archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us =---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list<webdna.jpg>.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77D--. Donovan Brooke
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
update on wn searching (1997) Enhancement Request for WebCatalog-NT (1996) what's wrong with this picture (2006) WebCat2 - [format thousands] (1997) WC2f3 (1997) Multiple Pulldowns (1997) [OT] ODBC between IIS and remote Access problem (2000) Error Log.db --however (1997) No more misunderstanding ... yay! :) (1997) [showif] question (2000) select multiple 2 more cents (1997) Parameter Passing Value (2002) Separate SSL Server (1997) [Sum] function? (1997) verify email address (1998) Search returns all, not 20 (1997) WCS Newbie question (1997) all records returned. (1997) WebTEN vs webSTAR (1998) WebCat for Unix?? (1997)