Re: [WebDNA] "Safe Write for Database" setting....

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112629
interpreted = N
texte = 212 --Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Are 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 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-1B57ADF2B77D Content-Type: text/html; charset=utf-8 Content-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 Mobile

On Mar 15, 2= 016, at 3:15 PM, Rich Kwas <= richkwasniewski@yahoo.com> wrote:

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

Safe 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.2
I 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.


--------------------------------------------------------- This message is sent 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
<webdna.jpg>
= --------------------------------------------------------- This message is sent 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-1B57ADF2B77D-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] "Safe Write for Database" setting.... (Terry Wilson 2016)
  2. Re: [WebDNA] "Safe Write for Database" setting.... ("Terry Wilson" 2016)
  3. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  4. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  5. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  6. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
  7. Re: [WebDNA] "Safe Write for Database" setting.... (Kenneth Grome 2016)
  8. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  9. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
  10. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  11. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  12. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
212 --Apple-Mail-6FF7175D-227E-472D-BA09-1B57ADF2B77D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Are 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 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-1B57ADF2B77D Content-Type: text/html; charset=utf-8 Content-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 Mobile

On Mar 15, 2= 016, at 3:15 PM, Rich Kwas <= richkwasniewski@yahoo.com> wrote:

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

Safe 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.2
I 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.


--------------------------------------------------------- This message is sent 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
<webdna.jpg>
= --------------------------------------------------------- This message is sent 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-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:

File Upload Problems (HELP!) (2000) Newbie question (1998) ListDatabases & ShowIf (2003) WC 2.0 frames feature (1997) new orderfile params... (2003) Cookie still not working (1999) Where is f2? (1997) Sami (1998) WebCat for mass emailings (1997) cybercash (2002) Sorting error (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) A matter of time (1997) problems with 2 tags (1997) Sku numbers (1997) Resetting a Formvariable (2000) Problems getting parameters passed into email. (1997) Not really WebCat- (1997) b12 cannot limit records returned and more. (1997) searchable list archive (1997)