Re: Open Databases on Restart

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22476
interpreted = N
texte = >One of my sites has databases with over 2 million records which need to be >opened everytime the server is started rather than have the user start the >database on demand and wait the long time for the database(s) to load which >is over 30 seconds for one database. > >I'm looking for some simple way to open selected databases on startup >rather than open a browser which redirects to the templates required using >vital RAM. Anybody got a simple solution?Use the triggers.db to call a special template every few seconds. In that special template, use [listdatabases] with [showif] to determine if the specific db you want opened is currently closed or open. If it is open, do nothing. If it is closed, execute a search or lookup -- which will open it.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Open Databases on Restart (Paul Uttermohlen 1999)
  2. Re: Open Databases on Restart (Paul Uttermohlen 1999)
  3. Re: Open Databases on Restart (Mícheál O Sé 1999)
  4. Re: Open Databases on Restart (Bob Minor 1999)
  5. Re: Open Databases on Restart (Kenneth Grome 1999)
  6. Open Databases on Restart (Morris Camp 1999)
>One of my sites has databases with over 2 million records which need to be >opened everytime the server is started rather than have the user start the >database on demand and wait the long time for the database(s) to load which >is over 30 seconds for one database. > >I'm looking for some simple way to open selected databases on startup >rather than open a browser which redirects to the templates required using >vital RAM. Anybody got a simple solution?Use the triggers.db to call a special template every few seconds. In that special template, use [listdatabases] with [showif] to determine if the specific db you want opened is currently closed or open. If it is open, do nothing. If it is closed, execute a search or lookup -- which will open it.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

WebCat2: multiple currency support (1997) thread7715.debug (1999) Re:multiple digests, please stop (1997) [OT] Disable/enable field (2003) PCS Frames (1997) Max Record length restated as maybe bug (1997) Unceremonious Unwanted Unsubscription (1999) More questions about serial number dishing (1997) Re:Virtual hosting and webcatNT (1997) URGENT: Can't email orders - HELP #2 (1998) database files in secure folder (1997) TCPSEND (1999) More examples? (2000) Ampersand Character (&) (1997) Dumb Question about Docs (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) problem serving foreign languages text (1997) Stinkin' [Referrer] (1998) Duplicate Carts (2006) Printing a final order (1997)