Re: [WebDNA] Serial numbers and pricing for WebDNA 7.0
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106116
interpreted = N
texte = I was looking at how MySQL is handling very large INSERTS and found = interesting comments here: http://dev.mysql.com/doc/refman/5.1/en/insert-speed.html Particularely this: "A very good workaround is to put the new rows into = a temp table, then flush that table every now and then in a single = tansaction. This makes the insert very quick, because all the checking = and conversion was already done in the temp table" I was wondering if we could not use the same way for very large WebDNA = databases: appending to temporary smaller database files that would be = merged to the main database using [appendfile] - chris On Jan 22, 2011, at 20:45, Govinda wrote: >=20 > On 2011-01-22, at 5:40 PM, christophe.billiottet@webdna.us wrote: >=20 >>=20 >> On Jan 22, 2011, at 14:52, Govinda wrote: >>=20 >>> Here is a very important question: >>> How are the SQL tags? Are they current? Bug free? Work with = MySQL? >>=20 >> There are two ways to access external db: ODBC or directly with = MySQL. Since the MySQL asccess is done through a MySQL lib from the = webserver itself, we always run the last version and it should work = without any problem. >=20 >=20 > OK great! Thanks Chris! >=20 > (I did not mean to show any lack of support.. I just needed to poke a = little to see if anyone was thinking of things on the heavy/burdened end = of things. There has never been any question about webdna's flawless = performance on the light end of the traffic/db-size spectrum.) >=20 > ------------ > Govinda >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I was looking at how MySQL is handling very large INSERTS and found = interesting comments here: http://dev.mysql.com/doc/refman/5.1/en/insert-speed.html Particularely this: "A very good workaround is to put the new rows into = a temp table, then flush that table every now and then in a single = tansaction. This makes the insert very quick, because all the checking = and conversion was already done in the temp table" I was wondering if we could not use the same way for very large WebDNA = databases: appending to temporary smaller database files that would be = merged to the main database using [appendfile] - chris On Jan 22, 2011, at 20:45, Govinda wrote: >=20 > On 2011-01-22, at 5:40 PM, christophe.billiottet@webdna.us wrote: >=20 >>=20 >> On Jan 22, 2011, at 14:52, Govinda wrote: >>=20 >>> Here is a very important question: >>> How are the SQL tags? Are they current? Bug free? Work with = MySQL? >>=20 >> There are two ways to access external db: ODBC or directly with = MySQL. Since the MySQL asccess is done through a MySQL lib from the = webserver itself, we always run the last version and it should work = without any problem. >=20 >=20 > OK great! Thanks Chris! >=20 > (I did not mean to show any lack of support.. I just needed to poke a = little to see if anyone was thinking of things on the heavy/burdened end = of things. There has never been any question about webdna's flawless = performance on the light end of the traffic/db-size spectrum.) >=20 > ------------ > Govinda >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
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:
Clean source code (2007)
formulas.db (1999)
WebCatalog 4.0.2rc1 and rc2 crash WebSTAR on quit (2001)
WC2f3 (1997)
Bug or syntax error on my part? (1997)
createfolder not behaving as expected (1999)
Problems with [Applescript] (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
search form problem.. (1997)
Math Function (1997)
Highlighting words found in a keyword search (2003)
Two submit buttons ? (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Setting up shop (1997)
Imagemagick, webdna, etc (2006)
Include a big block of text (1997)
Mac & Internet Explorer (2000)
[OT] Certs (2002)
Explorer 3.0/ Access Denied! (1997)
Couple of questions (1999)