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:
Field name-subcategory (1997)
WebCat2b15MacPlugin - [protect] (1997)
embedded showif statements (Ooops) (2000)
Encrypt (2000)
Verifying both name and password (was: THANKS) (1997)
Need relative path explanation (1997)
[delete] problem (2002)
WC1.6 to WC2 date formatting -FIXED! (1997)
html vs csi (Was: OT: 800x600) (2003)
[HIDEIF] inside [FOUNDITEM] (1997)
Mac carriage returns (2004)
lookup problem (2000)
MacWorld NY (2000)
Multiple adding (1997)
Price Change (2000)
Date Formats (1997)
product differences (1999)
HTTP Header info (1997)
OT: How to get more traffic to a site? (2005)
F*** you (1998)