Re: flushing databases

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50132
interpreted = N
texte = Similar to what Matthew said...[exclusivelock db=.db] [append] [replace] [delete] [/exclusivelock] [commitdatabase db=.db]DonovanMatthew Bohne wrote:>As I understand it, [closedatabase] saves and closes the database removing it from memory. It is not accessed again until it is needed. If this is an infrequently used databased, close might be your better option, it's going to get closed due to inactivity eventually anyway. > >[commitdatabase] saves the database file to disk and sort of refreshes the database in RAM. If you are making a change and then searching that database again immediately afterwards, commitdatabase is your better option. > >My standard usage is [commitdatabase] after a modification, unless I'm writing to a storage database that won't be used for a while. > >Form Submit -> [append]/[replace]/[delete] -> [commitdatabase] -> [redirect] > > > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: flushing databases (Donovan 2003)
  2. Re: flushing databases (Matthew Bohne 2003)
  3. Re: flushing databases (andy mowrey 2003)
  4. Re: flushing databases (andy mowrey 2003)
  5. Re: flushing databases (Charles Kline 2003)
  6. Re: flushing databases (Nitai @ ComputerOil 2003)
  7. Re: flushing databases (Laurent Bache 2003)
  8. flushing databases (Dave Hurley 2003)
Similar to what Matthew said...[exclusivelock db=.db] [append] [replace] [delete] [/exclusivelock] [commitdatabase db=.db]DonovanMatthew Bohne wrote:>As I understand it, [closedatabase] saves and closes the database removing it from memory. It is not accessed again until it is needed. If this is an infrequently used databased, close might be your better option, it's going to get closed due to inactivity eventually anyway. > >[commitdatabase] saves the database file to disk and sort of refreshes the database in RAM. If you are making a change and then searching that database again immediately afterwards, commitdatabase is your better option. > >My standard usage is [commitdatabase] after a modification, unless I'm writing to a storage database that won't be used for a while. > >Form Submit -> [append]/[replace]/[delete] -> [commitdatabase] -> [redirect] > > > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan

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:

Printing a final order (1997) Whats going on with my SERIAL NUMBER??? (1998) Limit to Field Length in DB (1998) Not really WebCat- (1997) Do not truncate a whole word (2004) FEA REQ: One .hdr, multiple .db's (2003) Can't use old cart file (was One more try) (1997) URGENT: WebDNA Server Not Running (2003) WebCat b13 CGI -shownext- (1997) [WebDNA] Append speed limits (2008) ShowIf helper? (1998) PCS Frames (1997) Error -108 (1997) Somebody to open my eyes!!! (2004) Closing db's & caching templates (was: Shippingcalculations) (1997) Sitebuilder ifs not matching [SMSI?] (2004) [WebDNA] Should I be able to use [setmimeheader =?UTF-8?Q?=20name=3DContent-Type=20=3F?= (2018) Reversing [ipaddress] normalization (1998) return missing item (was:WebCat Sales) (1997) Updating Prices in Online Database (1999)