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:
serial number generation (1997)
WebCatalog2 Feature Feedback (1996)
default value from Lookup (was Grant, please help me) (1997)
WebCat2: Items xx to xx shown, etc. (1997)
WebCat2 - Getting to the browser's username/password data (1997)
WebCAT has the devil in it! (2003)
File Upload (1997)
re: Large databases in WebCat (1997)
[ShowNext] feature in 2.0 (1997)
HideIf ip= OR ip= (1998)
select multiple 2 more cents (1997)
WebDNA for business intelligence? (2002)
European Convention (2004)
line breaks in sendmail (1998)
Re:E-Mailer (WebCatb15acgiMac) (1997)
[WebDNA] WebDNA Roll Call (2014)
Please.. copies of Digest for 7/29 and 7/30? (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
How to Display text in empty fields (1997)
Using Cookie for client specific info? (1997)