Re: [WebDNA] Is the AutoCommit preference still supported?
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105338
interpreted = N
texte = --Apple-Mail-17--188551769 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit 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: one two three four five > six seven eight nine ten [/!] 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-17--188551769 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable 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: one two = three four five six seven eight nine ten [/!] = 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?
Brian = Fries
BrainScan Software
=
= --Apple-Mail-17--188551769--
Associated Messages, from the most recent to the oldest:Or just manually open the db file and look at what's in = there, to compare, between each iteration of the test = loop?
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...