What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) WebCat b13 CGI -shownext- (1997) webcat- multiple selection in input field (1997) wc 2 pro users - sites, quotes wanted (1997) Listserver problem (1997) MacWEEK article help needed (1996) [shell] (2002) frustrated with search (2001) Sendmail on OSX/Communigate Pro (2002) Searching multiple fields (1997) PSC recommends what date format yr 2000??? (1997) Maximum of found items?? (2000) [WebDNA] Problem with administration (2009) [OT] DOD again (2003) Converting characters to numbers ... (1997) converted seed value? (1998) Performance Tuning (2006) Pgp&emailer (1997) [WebDNA] [OT] WebDNA Server Beta (2013) Help name our technology! I found it (1997)