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:

Newbie questions (1999) Web Catalog Instability (2000) Exclamation point (1997) I am sorry for always being such an ass (2004) Spreadsheet App pref. [OT] (2001) Correction: shipCost (2000) Opinion: [input] should be called [output] ... (1997) Umm...about those log files? (Off Topic) (1997) ACGI processing for .html (1997) emailer w/F2 (1997) Webcatalog on MacOs (2000) Summing fields (1997) Sendmail html/text and CCS problem (2003) Show if time tags (1997) OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998) DON'T use old cart file! (1997) Using files in an Email broadcast (1999) Re1000001: Setting up shop (1997) wierd [cart] action! (1997) FEW QUESTIONS (1997)