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:

Cart passing in URL... (2004) Off Topic: Personal Web Server (1998) Sorting by date (1997) Re:Variable Math (1998) WebCatalog2 Feature Feedback (1996) Setting up shop (1997) OSX b5 [listvariables] (2000) SET (1998) Date problems-more (1997) [random] only for 1-100??? (1997) Bug Report, maybe (1997) Shipping charges depending on tax rate? (1997) WC Database Format (1997) PIXO (1997) Secure server question (1997) Search/sort in URL Was: GuestBook example (1997) bypassing typo's (1998) Paths, relative paths, webstar server setup and security (Mac) (1997) WebCommerce: Folder organization ? (1997) Fw: Get your users off the phone lines (2001)