Re: [WebDNA] Is the AutoCommit preference still supported?

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105328
interpreted = N
texte = --Apple-Mail-10--246084591 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Brian The data will go into the db but the db will not be written to the HD - = if you have a crash then the data is lost. Try putting this at the end of the page to ensure that your data is = written to disk. [COMMITDATABASE db=3DFileName] Putting [COMMITDATABASE db=3DFileName] in your template causes the = specified database file (or full path) to be written but not closed (so = it will remain in RAM). This is only needed for special cases where you = want to be absolutely certain that a database has been written to disk. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 15/06/2010, at 10:16 AM, Brian Fries wrote: > I've been playing with the AutoCommit setting fro my databases. = Historically, I've always kept this on to ensure the integrity of my = data. However, I have an application now that really needs all the speed = it can get, and I'd like to disable AutoCommit. >=20 > When I turn off this setting, the databases are still getting written = to disk after every Append. This is with a simple loop that generates = data and appends it to a database. Each time through the loop, I use = [fileinfo] to check the size of the database, and it increases every = time. >=20 > OS X Server, WebDNA 6.1 >=20 > Brian Fries > BrainScan Software >=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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 --Apple-Mail-10--246084591 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Brian

The data will go into the db but the db will = not be written to the HD - if you have a crash then the data is = lost.

Try putting this at the end of the page = to ensure that your data is written to = disk.

[COMMITDATABASE db=3DFileName]

Putting = [COMMITDATABASE db=3DFileName] in your template causes the specified = database file (or full path) to be written but not closed (so it will = remain in RAM). This is only needed for special cases where you want to = be absolutely certain that a database has been written to = disk.



Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 15/06/2010, at 10:16 AM, Brian Fries wrote:

I've = been playing with the AutoCommit setting fro my databases. Historically, = I've always kept this on to ensure the integrity of my data. However, I = have an application now that really needs all the speed it can get, and = I'd like to disable AutoCommit.

When I turn off this setting, the = databases are still getting written to disk after every Append. This is = with a simple loop that generates data and appends it to a database. = Each time through the loop, I use [fileinfo] to check the size of the = database, and it increases every time.

OS X Server, WebDNA = 6.1

Brian Fries
BrainScan = Software


------------------------------------------------------= ---
This message is sent to you because you are subscribed to
the = mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi= stArchive/
Bug Reporting: htt= p://forum.webdna.us/eucabb.html?page=3Dtopics&category(8
=

= --Apple-Mail-10--246084591-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Is the AutoCommit preference still supported? (Donovan Brooke 2010)
  2. Re: [WebDNA] Is the AutoCommit preference still supported? (Govinda 2010)
  3. Re: [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
  4. Re: [WebDNA] Is the AutoCommit preference still supported? (Donovan Brooke 2010)
  5. Re: [WebDNA] Is the AutoCommit preference still supported? (Stuart Tremain 2010)
  6. Re: [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
  7. Re: [WebDNA] Is the AutoCommit preference still supported? (Stuart Tremain 2010)
  8. [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
--Apple-Mail-10--246084591 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Brian The data will go into the db but the db will not be written to the HD - = if you have a crash then the data is lost. Try putting this at the end of the page to ensure that your data is = written to disk. [COMMITDATABASE db=3DFileName] Putting [COMMITDATABASE db=3DFileName] in your template causes the = specified database file (or full path) to be written but not closed (so = it will remain in RAM). This is only needed for special cases where you = want to be absolutely certain that a database has been written to disk. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 15/06/2010, at 10:16 AM, Brian Fries wrote: > I've been playing with the AutoCommit setting fro my databases. = Historically, I've always kept this on to ensure the integrity of my = data. However, I have an application now that really needs all the speed = it can get, and I'd like to disable AutoCommit. >=20 > When I turn off this setting, the databases are still getting written = to disk after every Append. This is with a simple loop that generates = data and appends it to a database. Each time through the loop, I use = [fileinfo] to check the size of the database, and it increases every = time. >=20 > OS X Server, WebDNA 6.1 >=20 > Brian Fries > BrainScan Software >=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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: = http://forum.webdna.us/eucabb.html?page=3Dtopics&category(8 --Apple-Mail-10--246084591 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Brian

The data will go into the db but the db will = not be written to the HD - if you have a crash then the data is = lost.

Try putting this at the end of the page = to ensure that your data is written to = disk.

[COMMITDATABASE db=3DFileName]

Putting = [COMMITDATABASE db=3DFileName] in your template causes the specified = database file (or full path) to be written but not closed (so it will = remain in RAM). This is only needed for special cases where you want to = be absolutely certain that a database has been written to = disk.



Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 15/06/2010, at 10:16 AM, Brian Fries wrote:

I've = been playing with the AutoCommit setting fro my databases. Historically, = I've always kept this on to ensure the integrity of my data. However, I = have an application now that really needs all the speed it can get, and = I'd like to disable AutoCommit.

When I turn off this setting, the = databases are still getting written to disk after every Append. This is = with a simple loop that generates data and appends it to a database. = Each time through the loop, I use [fileinfo] to check the size of the = database, and it increases every time.

OS X Server, WebDNA = 6.1

Brian Fries
BrainScan = Software


------------------------------------------------------= ---
This message is sent to you because you are subscribed to
the = mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi= stArchive/
Bug Reporting: htt= p://forum.webdna.us/eucabb.html?page=3Dtopics&category(8
=

= --Apple-Mail-10--246084591-- 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:

Re:quit command on NT (1997) Default admin bug and how tech support reacted to it. (2000) Max Record length restated as maybe bug (1997) RE: New WebCatalog Version !!! (1997) Download Question (1997) 2nd WebCatalog2 Feature Request (1996) 3.08 installer (2003) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Interpret Around Contexts? (2000) Initiating NewCart (1997) Error Page? (1997) Need relative path explanation (1997) WebCatalog for Postcards ? (1997) problems with 2 tags shakur (1997) Urgent WebCatalog problem (2000) Associative lookup style? + bit more (1997) Search in 2 or more catalogs (1997) PSC recommends what date format yr 2000??? (1997) Summing fields (1997) Alternative to Authorize.net (2002)