[WebDNA] Is the AutoCommit preference still supported?

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105327
interpreted = N
texte = 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 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)
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 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:

Who is John Jakovich? (1999) Redirect frame targets (1998) Counting LineItems (2000) Trouble with formula.db (1997) Opinion Poll Please (2002) Emailer update for Mac? (1998) Programmers.org (2004) About Include (2001) OT : Site speed feedback (2002) # fields limited? (1997) Download URL & access on the fly ? (1997) remotely add + sign (1997) This list needs a digest: rant, rave... (1997) More on the email templates (1997) how to use WebCat w. SSL & CyberCash (1998) SV: Mass Mail (2000) WebCatalog2 Feature Feedback (1996) Sorting Numbers (1997) remotely add + sign (1997) search command (1999)