=--Apple-Mail-1--188043867-- Associated Messages, from the most recent to the oldest: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 =FriesBrainScan Software
=------------Govinda
=
|
=--Apple-Mail-1--188043867-- Donovan Brookeany =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 =FriesBrainScan Software
=------------Govinda
=
DOWNLOAD WEBDNA NOW!
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...