Re: [WebDNA] [store] and [recall]: default db location
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112074
interpreted = N
texte = > Why would it matter if the same volume of data were stored in a > single db or in separate dbs? Just want to take this opportunity to make a parenthesis: several small = databases are usually faster than a large one. Why is this? because one = single modification in a database, in case "Automatically commit = databases to disk after modification" is checked, will have to write few = hundred KB or few MB instead of tens or hundreds of MB to disk. Also, = smaller databases use smaller chunks of RAM. For a instance, a *very* large database with millions of entries would = be faster if split, using a small switch as entry point. For instance = let say the database stores names. It is divided into 26 smaller db, = each one storing the names starting with a specific letter: "a", "b", = "c", "d", =85 The entry point (search, append, whatever=85) will extract the first = letter of the query and point the query at the proper db. Since we can expect that not all the databases will be opened at the = same time, RAM usage will also be lower, and a very large database = (several GB) will be easier to open if the server does not have a lot of = RAM. - chris=
Associated Messages, from the most recent to the oldest:
> Why would it matter if the same volume of data were stored in a > single db or in separate dbs? Just want to take this opportunity to make a parenthesis: several small = databases are usually faster than a large one. Why is this? because one = single modification in a database, in case "Automatically commit = databases to disk after modification" is checked, will have to write few = hundred KB or few MB instead of tens or hundreds of MB to disk. Also, = smaller databases use smaller chunks of RAM. For a instance, a *very* large database with millions of entries would = be faster if split, using a small switch as entry point. For instance = let say the database stores names. It is divided into 26 smaller db, = each one storing the names starting with a specific letter: "a", "b", = "c", "d", =85 The entry point (search, append, whatever=85) will extract the first = letter of the query and point the query at the proper db. Since we can expect that not all the databases will be opened at the = same time, RAM usage will also be lower, and a very large database = (several GB) will be easier to open if the server does not have a lot of = RAM. - chris=
christophe.billiottet@webdna.us
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:
[WebDNA] WebDNA 8.6 Ubuntu 16.04 (2018)
PIXO support (1997)
Help with WebCatalog (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
FTP Address (2003)
Still Stumped on ShowNext...HELP! (1997)
Proper file locations (1997)
Processing all html files through WebCat or Typhoon (1998)
Download capabilities (1997)
[WebDNA] Finding duplicate email addresses (2008)
WebCatalog2 Feature Feedback (1996)
emailer error -108 (1997)
mail list (1998)
[delete] problem (1997)
Need relative path explanation (1997)
Error Log.db --however (1997)
[LOOKUP] (1997)
WebCat2 Append problem (B14Macacgi) (1997)
WebCat2 several catalogs? (1997)
Press Release hit the NewsWire!!! (1997)