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] Clean URLS job - will pay (2010)
WebCat2 - Getting to the browser's username/password data (1997)
Wierd thing in ViewOrder.tpl (1999)
PCS Frames (1997)
MacAuthorize order data fields WAS:How To question... (1997)
WebMerchant & CC Response (2002)
Plugin or CGI or both (1997)
expired beta (1997)
[WebDNA] WebDNA not parsing php files (2012)
Web*3 virtual hosting Webcatalog problem (1998)
Re:quit command on NT (1997)
nesting limits? (1998)
UPS Shipping (1999)
[OT] Form Check java problem (2003)
all records returned. (1997)
Limiting user access to .tmpl files (1997)
insert graphic in email (2000)
Error.html (1997)
triggers (2002)
Signal Raised Error (1997)