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 wordlast week that there is a bug in that feature. I've tried to set upsomething similar but could not get ANY trigger to work.Another simple solution is to use CRON, the application that triggers wasmeant to mimic. You can set it to load a bookmark of a .tpl that searchesthe database to load it. Cron can trigger a bookmark at a set intervalafter 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:
I would use triggers. But triggers seem to be MIA. There was some wordlast week that there is a bug in that feature. I've tried to set upsomething similar but could not get ANY trigger to work.Another simple solution is to use CRON, the application that triggers wasmeant to mimic. You can set it to load a bookmark of a .tpl that searchesthe database to load it. Cron can trigger a bookmark at a set intervalafter 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)