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:
looping table rows (1999)
[WebDNA] Problem saving returned value as a variable (2012)
WebCat2 several catalogs? (1997)
If Empty ? (1997)
shipping costs (1997)
Remote stockroom ? (1998)
date (2002)
[WebDNA] Copyfolder - preserve file dates (2014)
Why does setheader provide a db= parameter? (2005)
Database Advice (1996)
Signal Raised Error (Part III) (1997)
quitting (1997)
Cart Database (1999)
WebCat hosting sites? (1998)
[SHOWIF AND/OR] (1997)
[WebDNA] Code Library (2013)
Emailer & IMail List Server (1998)
Generating Report Totals (1997)
Trouble with [fileinfo] - update (2004)
Search with Special Chars (1997)