Re: [WebDNA] To Commitdatabase or Not to Commitdatabase

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108441
interpreted = N
texte = > > If I was to gain speed / performance by choosing one > > over the other then that is what I am looking for. Prefs for fastest db performance: AutoCommit=F ImmediateAppend=F MaxAppends=? (probably a very high integer value) SafeWriteDatabase=0 WebDNA tags to avoid for fastest db performance: [commitdatabase] [closedatabase] [flushdatabases] Note that doing all this will be risky and likely result in data loss sooner or later, but it should also result in the fastest db performance. Sincerely, Kenneth Grome Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Kenneth Grome 2012)
  2. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (christophe.billiottet@webdna.us 2012)
  3. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Palle Bo Nielsen 2012)
  4. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Govinda 2012)
  5. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Palle Bo Nielsen 2012)
  6. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Govinda 2012)
  7. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Palle Bo Nielsen 2012)
  8. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Govinda 2012)
  9. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Palle Bo Nielsen 2012)
  10. Re: [WebDNA] To Commitdatabase or Not to Commitdatabase (Govinda 2012)
  11. [WebDNA] To Commitdatabase or Not to Commitdatabase (Palle Bo Nielsen 2012)
> > If I was to gain speed / performance by choosing one > > over the other then that is what I am looking for. Prefs for fastest db performance: AutoCommit=F ImmediateAppend=F MaxAppends=? (probably a very high integer value) SafeWriteDatabase=0 WebDNA tags to avoid for fastest db performance: [commitdatabase] [closedatabase] [flushdatabases] Note that doing all this will be risky and likely result in data loss sooner or later, but it should also result in the fastest db performance. Sincerely, Kenneth Grome Kenneth Grome

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:

Mac: LModelDirector bug fix (1997) easy numfound search? (2001) Country & Ship-to address & other fields ? (1997) Location of Webcat site in folder hierarchy (1997) 06/06/2000 bug warning ... (2000) formula inside database to calculate weights (1997) [WebDNA] WebDNA is not parsing CSS file (2010) SQL statements (2002) Problems reading files created by WC (1997) Looping control (1997) Quitting WebMerchant ? (1997) webDNA and ASP pages (1997) database freeze (1997) WebCat2 - many [carts] on one template page? (1997) [Webcat 2]Next (1997) multiple databases (1997) Autoreturn Submit? (1997) Nested Loops and SHOWIFs (1997) setting taxable to true (1997) [shownext] and sort (1998)