2016

It keeps the original formatting.

= wrote:=20 From memory, there was a bug in =E2=80=9CAutomatically commit databases to= disk after modification=E2=80=9D, I wonder if this was associated with you=r problem ?You can always add=C2=A0[COMMITDATABASE db=3DFileName] after the modificati=on just to make sure.Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 07:15, Rich Kwas wrote:Is it safe to disable ""Safe Write for Database" in Preferences???=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DSafe 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 comp=letely flushed to disk. This helps to eliminate corruption 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=3DIf I disable this setting will all changes be written to the db on the HD i=mmediately, =C2=A0without 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 f=ew 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 change=d recently or much over that time span...There is no consistency to this issue.It happens (like today) but may not h=appen for days or weeks.I'm wondering if this "temporary file" and the original database on disk ar=e somehow under some circumstances getting out of sync.The db isn't that large, having 2,111 records,151 Fields and using 4,759K o=f ram.I'm wondering if disabling "Safe Write" might be an option to try and preve=nt this in the future.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 =C2=A0this iss=ue in the past as well.I'm on Windows Server2008 using vers.6.2I have nearly 1gb of unused ram on =the server, plenty of hard drive space....I've attached a screen capture of my Preferences in case anything else can =be tinkered with.---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ------=_Part_640510_538627000.1458076197642Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

I already using [COMM=ITDATABASE db=3DFileName] in all the admin pages where they edit these ads.=...

=Problem still pops up every no=w and then, like today again.

Tho=ughts on the "Safe Write" setting?

On Tuesday=, March 15, 2016 4:01 PM, Stuart Tremain <webdna@idfk.com.au> wrote:<=br>

From memory, there was a bug in =E2=80=9CAutomatically commit= databases to disk after modification=E2=80=9D, I wonder if this was associ=ated with your problem ?

You can always add&=nbsp;[COMMITDATABASE db=3DFileName] after the modification just to make sur=e.

Kind regards

Stu=art Tremain

IDFK Web Developments

AUSTRALIA

webd=na@idfk.com.au

On 16 Mar 2016, at 07:15, R=ich Kwas <richkwasniewski@yahoo.com> wrote:
Is it safe to disable ""Safe Write for Database" in= Preferences???

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Safe Write DB:
Enabled by default. Sets the We=bDNA engine to create a temporary file when writing the contents of a datab=ase to disk. The temporary file contents are then moved to the original dat=abase file after the entire database is completely flushed to disk. This he=lps to eliminate corruption of the original database file if there is an in=terruption 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 changes be written to the db on the =HD immediately, without that need for a temporary file?
<=div class=3D"yiv7544201727" dir=3D"ltr" id=3D"yiv7544201727yui_3_16_0_1_145=8071741244_2537">
I've been having this issue "again" where a client says they make =changes to ad listings stored in the database, but then all the changes are= gone a few 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 time span...

There is no consistency to this= issue.
It happens (like today) but may not happen f=or days or weeks.

I'm wondering if this "temporary file" and= the original database on disk are somehow under some circumstances 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 disab=ling "Safe Write" might be an option to try and prevent this in the future.=

Very frustrating for the client.I can't seem to duplicate i=t myself,but I believe them when they say it happens.I may have posted abou=t this issue in the past as well.

I'm on Windows Server2008 us=ing vers.6.2
I have nearly 1gb of unused ram on the =server, plenty of hard drive space....

I've attached a screen captur=e of my Preferences in case anything else can be tinkered with.

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us<webdna.jpg>

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us