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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)