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:
Changing buttons (1999)
problems with 2 tags (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
More Applescript (1997)
Authorizenet and expiration dates (2002)
line endings for Mac OS X files? (2003)
Re WebDNA has reached it connection limit (2004)
possible, WebCat2.0 and checkboxes-restated (1997)
SiteEditPro (1996)
Silly little OT question (2004)
Change in Host? (1999)
NetSplat and WebCat2 (1997)
'0' vs. blank (2005)
[OT] html background att (2003)
RE: OK, here goes... (1997)
Format of Required fields error message (1997)
Paths (1998)
Postdata expired from cache (2004)
WebDNA on Linux (2005)
2.0Beta Command Ref (can't find this instruction) (1997)