Re: [WebDNA] Limts? -and- Hot Merge
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102340
interpreted = N
texte = Please also note that MySQL database are several times as large as WebDNA databases. If we take Matthew's experience: "Each of the 100 websites has 120+ databases. Each website had 3 databases dedicated to user tracking (a record of every product and page viewed), that's 300 tracking databases. Of the 300 tracking databases, about 10 of them had reached 300MB+ in size, that's 3GB." Compared to one of our MySQL5 dedicated server, 300 databases and 4000 tables for 300 "standard websites" (so, 4 times smaller than Matthew's customers databases), we need more than 30GB of disk space and 8GB RAM to handle it (just MySQL + linux), and it runs slower... as a matter of fact, a [lookup] is 50 times slower with MySQL than it is with WebDNA (CICADA). - chris
Associated Messages, from the most recent to the oldest:
Please also note that MySQL database are several times as large as WebDNA databases. If we take Matthew's experience: "Each of the 100 websites has 120+ databases. Each website had 3 databases dedicated to user tracking (a record of every product and page viewed), that's 300 tracking databases. Of the 300 tracking databases, about 10 of them had reached 300MB+ in size, that's 3GB." Compared to one of our MySQL5 dedicated server, 300 databases and 4000 tables for 300 "standard websites" (so, 4 times smaller than Matthew's customers databases), we need more than 30GB of disk space and 8GB RAM to handle it (just MySQL + linux), and it runs slower... as a matter of fact, a
[lookup] is 50 times slower with MySQL than it is with WebDNA (CICADA). - 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:
WebCatalog 2.1b4/Mac available (1997)
WebCommerce: Folder organization ? (1997)
Execute Applescript (1997)
No incentive ... (2000)
Variables (1999)
Using Applescript to process WebCatalog functions (1998)
Internet Explorer and caching (2000)
Alternative colors? (2000)
Tracking System? (1997)
Simple way to create unique SKU (1997)
[WebDNA] Anyone knows how to shell reboot? (2013)
Storebuilder Quickie (2003)
weight based shipping cost questions (1997)
WebCatalog 4.0.2b5 available (2000)
$adminput doesn't allow [include] files (1997)
Forcing a NEWCART (1997)
Version 2.0 and 1.6 simultaneous (1997)
Template transformed itself into a database? (1998)
[shownext max (1997)
Slow NT mail. (2000)