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

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112630
interpreted = N
texte = 213 --Apple-Mail=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Are you getting a lot of .db-tmp files being written for the db ? If you are then there could be a problem with either your code or some = of the content, based on the fact that the site has been operational for = many years, I would open the .db file and check the content, also check = your error log.txt Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 16 Mar 2016, at 08:09, Rich Kwas wrote: >=20 > I already using [COMMITDATABASE db=3DFileName] in all the admin pages = where they edit these ads... >=20 > Problem still pops up every now and then, like today again. >=20 > Thoughts on the "Safe Write" setting? >=20 >=20 > On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain = wrote: >=20 >=20 > =46rom 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 your problem ? >=20 > You can always add [COMMITDATABASE db=3DFileName] after the = modification just to make sure. >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 16 Mar 2016, at 07:15, 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 = completely 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=3D >>=20 >> If I disable this setting will all changes be written to the db on = the HD immediately, without that need for a temporary file? >>=20 >> 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.... >>=20 >> This site has been for over 10 years and the admin area has not been = changed 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 are 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 of ram. >>=20 >> I'm wondering if disabling "Safe Write" might be an option to try and = prevent this in the future. >>=20 >> Very frustrating for the client.I can't seem to duplicate it = myself,but I believe them when they say it happens.I may have posted = about this issue in the 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 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 >=20 > --------------------------------------------------------- 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 >=20 >=20 > --------------------------------------------------------- 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=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Are you getting a lot of .db-tmp files being written for the = db ?

If you are then = there could be a problem with either your code or some of the content, = based on the fact that the site has been operational for many years, I = would open the .db file and check the content, also check your error = log.txt

Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 16 Mar 2016, at 08:09, Rich Kwas <richkwasniewski@yahoo.com> wrote:

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

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

Thoughts on the "Safe = Write" setting?


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


=46rom 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 your problem ?

You can always add [COMMITDATABASE = db=3DFileName] after the modification just to make sure.

Kind regards
Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au





On 16 Mar 2016, at 07:15, Rich 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 = 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 completely 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=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?

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 for 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 = disabling "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 it myself,but I believe them when = they say it happens.I may have posted about  this issue in the past = as well.


I'm on Windows = Server2008 using vers.6.2
I 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 sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/l= ist/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:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us


--------------------------------------------------------- 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

= --------------------------------------------------------- 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=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1-- . 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)
213 --Apple-Mail=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Are you getting a lot of .db-tmp files being written for the db ? If you are then there could be a problem with either your code or some = of the content, based on the fact that the site has been operational for = many years, I would open the .db file and check the content, also check = your error log.txt Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 16 Mar 2016, at 08:09, Rich Kwas wrote: >=20 > I already using [COMMITDATABASE db=3DFileName] in all the admin pages = where they edit these ads... >=20 > Problem still pops up every now and then, like today again. >=20 > Thoughts on the "Safe Write" setting? >=20 >=20 > On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain = wrote: >=20 >=20 > =46rom 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 your problem ? >=20 > You can always add [COMMITDATABASE db=3DFileName] after the = modification just to make sure. >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 16 Mar 2016, at 07:15, 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 = completely 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=3D >>=20 >> If I disable this setting will all changes be written to the db on = the HD immediately, without that need for a temporary file? >>=20 >> 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.... >>=20 >> This site has been for over 10 years and the admin area has not been = changed 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 are 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 of ram. >>=20 >> I'm wondering if disabling "Safe Write" might be an option to try and = prevent this in the future. >>=20 >> Very frustrating for the client.I can't seem to duplicate it = myself,but I believe them when they say it happens.I may have posted = about this issue in the 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 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 >=20 > --------------------------------------------------------- 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 >=20 >=20 > --------------------------------------------------------- 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=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Are you getting a lot of .db-tmp files being written for the = db ?

If you are then = there could be a problem with either your code or some of the content, = based on the fact that the site has been operational for many years, I = would open the .db file and check the content, also check your error = log.txt

Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 16 Mar 2016, at 08:09, Rich Kwas <richkwasniewski@yahoo.com> wrote:

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

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

Thoughts on the "Safe = Write" setting?


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


=46rom 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 your problem ?

You can always add [COMMITDATABASE = db=3DFileName] after the modification just to make sure.

Kind regards
Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au





On 16 Mar 2016, at 07:15, Rich 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 = 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 completely 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=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?

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 for 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 = disabling "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 it myself,but I believe them when = they say it happens.I may have posted about  this issue in the past = as well.


I'm on Windows = Server2008 using vers.6.2
I 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 sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webdna.us/l= ist/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:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us


--------------------------------------------------------- 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

= --------------------------------------------------------- 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=_698406E2-B8D1-4ACC-8F3D-8BF41B707FC1-- . Stuart Tremain

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:

Quit revisited (1997) Shopping Cart Limits? (1998) PayFloPro New SDK & Macintosh (2002) (1997) form data submission gets truncated (1997) RE: Can't get appendfile to work (1997) no global [username] or [password] displayed ... (1997) Upload Maximum (2003) Windows nt service pack 3 upgrade (1997) Format of Required fields error message (1997) WebCatalog seems to choke on large (2meg) html files. (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) hiding links (1999) sort problems....bug or brain fart? (1997) Problems with [Search] param - Mac Plugin b15 (1997) Weird bug, or is there something amiss? (1997) Math with Time (1997) Authenticate (2000) AND/OR searches in WebCat 3.07 (2003) WebCat2 - many [carts] on one template page? (1997)