Re: Open Databases on Restart

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22496
interpreted = N
texte = I would use triggers. But triggers seem to be MIA. There was some word last week that there is a bug in that feature. I've tried to set up something similar but could not get ANY trigger to work.Another simple solution is to use CRON, the application that triggers was meant to mimic. You can set it to load a bookmark of a .tpl that searches the database to load it. Cron can trigger a bookmark at a set interval after startup. I am using it until the triggers bug is killed.Paul>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? > >Thanks, > >Morris Camp >.------------------------------------------------------. >| Morris Camp Industry Publications | >| 8841 Escambia Avenue | >| (334)961-7111 voice Perdido Beach, AL 36530 | >| (334)961-7110 fax email:morris@indypubs.com | >\------------------------------------------------------' _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ 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)
I would use triggers. But triggers seem to be MIA. There was some word last week that there is a bug in that feature. I've tried to set up something similar but could not get ANY trigger to work.Another simple solution is to use CRON, the application that triggers was meant to mimic. You can set it to load a bookmark of a .tpl that searches the database to load it. Cron can trigger a bookmark at a set interval after startup. I am using it until the triggers bug is killed.Paul>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? > >Thanks, > >Morris Camp >.------------------------------------------------------. >| Morris Camp Industry Publications | >| 8841 Escambia Avenue | >| (334)961-7111 voice Perdido Beach, AL 36530 | >| (334)961-7110 fax email:morris@indypubs.com | >\------------------------------------------------------' _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Paul Uttermohlen

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:

search form problem.. (1997) Unknown error: OrderNotCreated (1997) sort problems....bug or brain fart? (1997) NetCloak, FireSite and PIXO (2000) PGP (2003) New index for docs (1997) Strange search... (2001) [ANN] The ZipBurst CGI 2.5 & Trial Size Special (2001) Country & Ship-to address & other fields ? (1997) Opening 'order file'. (1999) WebCatalog2 Feature Feedback (1996) Rss and Webcat and conversion (2006) Cart# (1997) question: search return in order (1997) WebCat chatroom (1997) [WebDNA] Advices for Linux Config (2017) Stinkin' [Referrer] (1998) OT: number of options in select menu (2002) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Nested Loops and SHOWIFs (1997)