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:

[quantity] - spoke too soon (1997) Re:Copyright ? (1997) convertWords... NEW (2001) [OT] Security in general [Was] WebDNA security (2004) Interesting speed comparison .. (2003) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) page redirect in webDNA (1997) suffix mapping for NT? (1997) update on include (1997) Mult-File Upload w/ Web Star (2000) BBEdit and WebCatalog 2.0? (1997) Seeking Better Display of results... (1997) 2nd WebCatalog2 Feature Request (1996) Help formatting search results w/ table (1997) Testing the WebCat Email List Members (2000) Huge databases and RAM (1998) Problem with encrypted cookies (2000) Template Encrypt Speed (1998) Sales Tax db (1998) Setting up WebCatalog with Retail Pro data (1996)