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:
Pithy questions on webcommerce & siteedit (1997)
Webcat 3 Bug?!?! Netscape + Protect + Posted Form (1998)
Running _every_ page through WebCat ? (1997)
Emailer help....! (1997)
Email notification to one of multiple vendors ? (1997)
b12 cannot limit records returned and more. (1997)
show all problem (1997)
Email Formatting (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
PROBLEM (1997)
[WebDNA] anyone set up webdna 7 with virtual hosts on mac? (2012)
Signal Raised (1997)
WebCatalog f2 Installation (1997)
Time/date formatting %X doesn't work ... (1997)
Running 2 two WebCatalog.acgi's (1996)
Share Bulletin Board? (1998)
Cyberstudio and WebDNA (1997)
Me know logical no need (2002)
Ongoing group search problems ... (1997)
Help with a pull down menu (1999)