Re: autocommit problem

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19081
interpreted = N
texte = >Replace writes to disk every few hundred or so operations, for internal >reasons. This probably explains what I'm seeing and why what I want to do won't work. It's a huge file (100 Megs) and the last thing I want is for it to be written to disk often. And every few hundred or so operations is a tad too frequent for this purpose on a live server (and explains why I don't see it on low traffic beta site). Is it just writing the changes or flushing the whole darn database?Is there a way to prevent this writing to disk besides autocommit off, which only works to a limited degree? If not, my next post will probably be about how to do what I'm trying to do! ;-)ThanksSandy Associated Messages, from the most recent to the oldest:

    
  1. Re: autocommit problem (Angel Bennett 1998)
  2. Re: autocommit problem (Angel Bennett 1998)
  3. Re: autocommit problem (Angel Bennett 1998)
  4. Re: autocommit problem (Angel Bennett 1998)
  5. Re: autocommit problem (Kenneth Grome 1998)
  6. Re: autocommit problem (PCS Technical Support 1998)
  7. Re: autocommit problem (Kenneth Grome 1998)
  8. Re: autocommit problem (Sandra L. Pitner 1998)
  9. Re: autocommit problem (Sandra L. Pitner 1998)
  10. Re: autocommit problem (Peter Ostry 1998)
  11. Re: autocommit problem (PCS Technical Support 1998)
  12. Re: autocommit problem (Sandra L. Pitner 1998)
  13. Re: autocommit problem (Kenneth Grome 1998)
  14. Re: autocommit problem (PCS Technical Support 1998)
  15. Re: autocommit problem (Gary Richter 1998)
  16. Re: autocommit problem (Sandra L. Pitner 1998)
  17. autocommit problem (Sandra L. Pitner 1998)
>Replace writes to disk every few hundred or so operations, for internal >reasons. This probably explains what I'm seeing and why what I want to do won't work. It's a huge file (100 Megs) and the last thing I want is for it to be written to disk often. And every few hundred or so operations is a tad too frequent for this purpose on a live server (and explains why I don't see it on low traffic beta site). Is it just writing the changes or flushing the whole darn database?Is there a way to prevent this writing to disk besides autocommit off, which only works to a limited degree? If not, my next post will probably be about how to do what I'm trying to do! ;-)ThanksSandy Sandra L. Pitner

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:

emailer (1997) error: Too many nested [xxx] contexts (1997) Giving out error pages (1997) Applescript in Webcatalog problem (1997) Logging users (1998) Replace/Commit not Replacing/Commiting (2000) [WebDNA] [switch] [case] only works with "=" comparisons.. true? (2009) WebTen? (1997) username = 115 (1999) [URL] and [showif] or [hideif] comparisons (2003) Country & Ship-to address & other fields ? (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) WCf2 and nested tags (1997) WebDNA Solutions ... sorry! (1997) Setting up shop (1997) emailer w/F2 (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Location of Webcat site in folder hierarchy (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Checksum failure [OT] (2002)