Re: [WebDNA] Is the AutoCommit preference still supported?

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105339
interpreted = N
texte = --Apple-Mail-1--188043867 Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit I verified Brian is correct using 'tail -f test.db' in a shell. - D =================== d.brooke - mobile www.euca.us =================== On Jun 15, 2010, at 11:21 AM, Govinda wrote: > any chance the [fileinfo] context is actually reading the copy of > the db in ram to get its returned data? Can you write the test to > weed out that possibility? > Or just manually open the db file and look at what's in there, to > compare, between each iteration of the test loop? > > On Jun 15, 2010, at 11:59 AM, Brian Fries wrote: > >> Simple test, nothing else running on this development server. I >> have a page called "autocommit.dna" that contains only the >> following code, and a database in the same folder called >> "autocommit.db" with the fields indicated in the code comments: >> >> >> [!] autocommit.db: onetwothreefourfive >> sixseveneightnineten [/!] AutoCommit Preference: [lookup >> db=webcatalog >> prefs&lookinfield=preference&value=AutoCommit&returnfield=value] >>
[text]tStart=[elapsedtime][/text] [text]tLoops=10[/text] [loop >> start=1&end=[tLoops]] [append db=autocommit.db]one=[index]&two= >> [math][index]*2[/math]&three=[math][index]*3[/math]&four=[math] >> [index]*4[/math]&five=[math][index]*5[/math]&six=[math][index]*6[/ >> math]&seven=[math][index]*7[/math]&eight=[math][index]*8[/math] >> &nine=[math][index]*9[/math]&ten=This is just some dummy text.[/ >> append] autocommit.db size: [fileinfo autocommit.db][size]
[/ >> fileinfo] [/loop] Elapsed: [math][elapsedtime]-[tStart][/math] for >> [tLoops] loops.
>> >> >> When I load the page, I get the following results: >> >> AutoCommit Preference: F >> autocommit.db size: 1213 >> autocommit.db size: 1267 >> autocommit.db size: 1322 >> autocommit.db size: 1378 >> autocommit.db size: 1435 >> autocommit.db size: 1492 >> autocommit.db size: 1549 >> autocommit.db size: 1606 >> autocommit.db size: 1663 >> autocommit.db size: 1721 >> Elapsed: 0 for 10 loops. >> >> As you can see, autocommit is off, and yet the database file on >> disk grows after every append. WebDNA has been restarted, so the >> preference certainly should be active. >> >> Can someone please try this on their server to verify my results? >> >> Thanks, >> >> Brian Fries >> BrainScan Software >> > > ------------ > Govinda > govinda.webdnatalk@gmail.com > > > > --Apple-Mail-1--188043867 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I verified Brian is correct using = 'tail -f test.db' in a shell. - = D

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
d.b= rooke - mobile
www.euca.us
=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On Jun 15, = 2010, at 11:21 AM, Govinda <govinda.webdnatalk@gmail.com<= /a>> wrote:

any = chance the [fileinfo] context is actually reading the copy of the db in = ram to get its returned data?  Can you write the test to weed out = that possibility?
Or just manually open the db file and look at = what's in there, to compare, between each iteration of the test = loop?

On Jun 15, 2010, at 11:59 AM, Brian Fries = wrote:

Simple test, nothing = else running on this development server. I have a page called = "autocommit.dna" that contains only the following code, and a database = in the same folder called "autocommit.db" with the fields indicated in = the code comments:


<!--HAS_WEBDNA_TAGS--> [!] autocommit.db: onetwo= threefourfivesixseveneightnineten [/!] = AutoCommit Preference: [lookup db=3Dwebcatalog = prefs&lookinfield=3Dpreference&value=3DAutoCommit&returnfield=3D= value]<br> [text]tStart=3D[elapsedtime][/text] = [text]tLoops=3D10[/text] [loop start=3D1&end=3D[tLoops]] [append = db=3Dautocommit.db]one=3D[index]&two=3D[math][index]*2[/math]&thre= e=3D[math][index]*3[/math]&four=3D[math][index]*4[/math]&five=3D[m= ath][index]*5[/math]&six=3D[math][index]*6[/math]&seven=3D[math][i= ndex]*7[/math]&eight=3D[math][index]*8[/math]&nine=3D[math][index]= *9[/math]&ten=3DThis is just some dummy text.[/append] autocommit.db = size: [fileinfo autocommit.db][size]<br>[/fileinfo] [/loop] = Elapsed: [math][elapsedtime]-[tStart][/math] for [tLoops] = loops.<br>


When I = load the page, I get the following = results:

AutoCommit Preference: = F
autocommit.db size: = 1213
autocommit.db size: = 1267
autocommit.db size: = 1322
autocommit.db size: = 1378
autocommit.db size: = 1435
autocommit.db size: = 1492
autocommit.db size: = 1549
autocommit.db size: = 1606
autocommit.db size: = 1663
autocommit.db size: = 1721
Elapsed: 0 for 10 = loops.

As = you can see, autocommit is off, and yet the database file on disk grows = after every append. WebDNA has been restarted, so the preference = certainly should be active.

Can someone please try this on = their server to verify my results?

Thanks,

Brian = Fries
BrainScan Software
=


= --Apple-Mail-1--188043867-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Is the AutoCommit preference still supported? (Donovan Brooke 2010)
  2. Re: [WebDNA] Is the AutoCommit preference still supported? (Govinda 2010)
  3. Re: [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
  4. Re: [WebDNA] Is the AutoCommit preference still supported? (Donovan Brooke 2010)
  5. Re: [WebDNA] Is the AutoCommit preference still supported? (Stuart Tremain 2010)
  6. Re: [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
  7. Re: [WebDNA] Is the AutoCommit preference still supported? (Stuart Tremain 2010)
  8. [WebDNA] Is the AutoCommit preference still supported? (Brian Fries 2010)
--Apple-Mail-1--188043867 Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit I verified Brian is correct using 'tail -f test.db' in a shell. - D =================== d.brooke - mobile www.euca.us =================== On Jun 15, 2010, at 11:21 AM, Govinda wrote: > any chance the [fileinfo] context is actually reading the copy of > the db in ram to get its returned data? Can you write the test to > weed out that possibility? > Or just manually open the db file and look at what's in there, to > compare, between each iteration of the test loop? > > On Jun 15, 2010, at 11:59 AM, Brian Fries wrote: > >> Simple test, nothing else running on this development server. I >> have a page called "autocommit.dna" that contains only the >> following code, and a database in the same folder called >> "autocommit.db" with the fields indicated in the code comments: >> >> >> [!] autocommit.db: onetwothreefourfive >> sixseveneightnineten [/!] AutoCommit Preference: [lookup >> db=webcatalog >> prefs&lookinfield=preference&value=AutoCommit&returnfield=value] >>
[text]tStart=[elapsedtime][/text] [text]tLoops=10[/text] [loop >> start=1&end=[tLoops]] [append db=autocommit.db]one=[index]&two= >> [math][index]*2[/math]&three=[math][index]*3[/math]&four=[math] >> [index]*4[/math]&five=[math][index]*5[/math]&six=[math][index]*6[/ >> math]&seven=[math][index]*7[/math]&eight=[math][index]*8[/math] >> &nine=[math][index]*9[/math]&ten=This is just some dummy text.[/ >> append] autocommit.db size: [fileinfo autocommit.db][size]
[/ >> fileinfo] [/loop] Elapsed: [math][elapsedtime]-[tStart][/math] for >> [tLoops] loops.
>> >> >> When I load the page, I get the following results: >> >> AutoCommit Preference: F >> autocommit.db size: 1213 >> autocommit.db size: 1267 >> autocommit.db size: 1322 >> autocommit.db size: 1378 >> autocommit.db size: 1435 >> autocommit.db size: 1492 >> autocommit.db size: 1549 >> autocommit.db size: 1606 >> autocommit.db size: 1663 >> autocommit.db size: 1721 >> Elapsed: 0 for 10 loops. >> >> As you can see, autocommit is off, and yet the database file on >> disk grows after every append. WebDNA has been restarted, so the >> preference certainly should be active. >> >> Can someone please try this on their server to verify my results? >> >> Thanks, >> >> Brian Fries >> BrainScan Software >> > > ------------ > Govinda > govinda.webdnatalk@gmail.com > > > > --Apple-Mail-1--188043867 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I verified Brian is correct using = 'tail -f test.db' in a shell. - = D

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
d.b= rooke - mobile
www.euca.us
=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On Jun 15, = 2010, at 11:21 AM, Govinda <govinda.webdnatalk@gmail.com<= /a>> wrote:

any = chance the [fileinfo] context is actually reading the copy of the db in = ram to get its returned data?  Can you write the test to weed out = that possibility?
Or just manually open the db file and look at = what's in there, to compare, between each iteration of the test = loop?

On Jun 15, 2010, at 11:59 AM, Brian Fries = wrote:

Simple test, nothing = else running on this development server. I have a page called = "autocommit.dna" that contains only the following code, and a database = in the same folder called "autocommit.db" with the fields indicated in = the code comments:


<!--HAS_WEBDNA_TAGS--> [!] autocommit.db: onetwo= threefourfivesixseveneightnineten [/!] = AutoCommit Preference: [lookup db=3Dwebcatalog = prefs&lookinfield=3Dpreference&value=3DAutoCommit&returnfield=3D= value]<br> [text]tStart=3D[elapsedtime][/text] = [text]tLoops=3D10[/text] [loop start=3D1&end=3D[tLoops]] [append = db=3Dautocommit.db]one=3D[index]&two=3D[math][index]*2[/math]&thre= e=3D[math][index]*3[/math]&four=3D[math][index]*4[/math]&five=3D[m= ath][index]*5[/math]&six=3D[math][index]*6[/math]&seven=3D[math][i= ndex]*7[/math]&eight=3D[math][index]*8[/math]&nine=3D[math][index]= *9[/math]&ten=3DThis is just some dummy text.[/append] autocommit.db = size: [fileinfo autocommit.db][size]<br>[/fileinfo] [/loop] = Elapsed: [math][elapsedtime]-[tStart][/math] for [tLoops] = loops.<br>


When I = load the page, I get the following = results:

AutoCommit Preference: = F
autocommit.db size: = 1213
autocommit.db size: = 1267
autocommit.db size: = 1322
autocommit.db size: = 1378
autocommit.db size: = 1435
autocommit.db size: = 1492
autocommit.db size: = 1549
autocommit.db size: = 1606
autocommit.db size: = 1663
autocommit.db size: = 1721
Elapsed: 0 for 10 = loops.

As = you can see, autocommit is off, and yet the database file on disk grows = after every append. WebDNA has been restarted, so the preference = certainly should be active.

Can someone please try this on = their server to verify my results?

Thanks,

Brian = Fries
BrainScan Software
=


=

= --Apple-Mail-1--188043867-- Donovan Brooke

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:

Cookie Newbie (2002) problems with 2 tags (1997) California Tax Rates (1998) Prices coming up 0.00 (2001) Using Plug-In while running 1.6.1 (1997) WebCatalog2 for NT Beta Request (1997) Progress !! WAS: Trouble with formula.db (1997) checking for [ and ] in form fields ... (1997) Emailer question (2003) PIXO with cometsite ... and/or other plugins (1998) Error Log.db --however (1997) Location of Webcat site in folder hierarchy (1997) Showif, Hideif reverse logic ? (1997) Using Cookie for client specific info? (1997) WebStar 4.2 issues (2000) [WriteFile] problems (1997) Template not completely processed (1998) File Upload (1997) Apache freak-out with webDNA (2008) unix permissions theory applied to db security? Or...? (2000)