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

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105329
interpreted = N
texte = --Apple-Mail-29--238920891 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Thanks, Stuart, but I'm afraid you missed my point, which is this: Even though AutoCommit is disabled in preferences, the database is still = being written to disk after every single Append context. Brian Fries BrainScan Software On Jun 14, 2010, at 5:22 PM, Stuart Tremain wrote: > Brian >=20 > 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. >=20 > Try putting this at the end of the page to ensure that your data is = written to disk. >=20 > [COMMITDATABASE db=3DFileName] >=20 > 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. >=20 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 15/06/2010, at 10:16 AM, Brian Fries wrote: >=20 >> 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 >=20 --Apple-Mail-29--238920891 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Thanks, Stuart, but I'm afraid you missed my point, which is = this:

Even though AutoCommit is disabled in = preferences, the database is still being written to disk after every = single Append context.

Brian = Fries
BrainScan Software

On Jun 14, 2010, at 5:22 PM, Stuart Tremain = wrote:

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-29--238920891-- 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-29--238920891 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Thanks, Stuart, but I'm afraid you missed my point, which is this: Even though AutoCommit is disabled in preferences, the database is still = being written to disk after every single Append context. Brian Fries BrainScan Software On Jun 14, 2010, at 5:22 PM, Stuart Tremain wrote: > Brian >=20 > 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. >=20 > Try putting this at the end of the page to ensure that your data is = written to disk. >=20 > [COMMITDATABASE db=3DFileName] >=20 > 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. >=20 >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 15/06/2010, at 10:16 AM, Brian Fries wrote: >=20 >> 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 >=20 --Apple-Mail-29--238920891 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Thanks, Stuart, but I'm afraid you missed my point, which is = this:

Even though AutoCommit is disabled in = preferences, the database is still being written to disk after every = single Append context.

Brian = Fries
BrainScan Software

On Jun 14, 2010, at 5:22 PM, Stuart Tremain = wrote:

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-29--238920891-- Brian Fries

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:

Fields font size (2003) Help! WebCat2 bug (1997) Re:no [search] with NT (1997) [WebDNA] WebDNA Email Auth Functioning? (2014) How To question on setting up downloads (1997) HomePage Caution (1997) WC2b15 File Corruption (1997) Line Feed problems ... (2002) WebCatalog as a ListServ (1998) shipping costs (2000) Calculating multiple shipping... (1997) Separate SSL Server (1997) RE: [WebDNA] ubuntu can't append db (2019) Upgrading 2.1 (2000) PSC recommends what date format yr 2000??? (1997) [WebDNA] Re:BCC and/or Character limit [sendmail] (2010) Same Database needed on two machines (2002) Database Strategy - more... (1998) [Fwd: F3 database munching] (1997) Requiring that certain fields be completed (1997)