Re: [WebDNA] Re: WebDNA7 site randomly dropping tags

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107631
interpreted = N
texte = --Apple-Mail-3-501172570 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Just setup a small test: this adds 10,000 records to a small database = and immediately read them in the same file: it is instantaneous on my = WebDNA 7 test server. --Apple-Mail-3-501172570 Content-Disposition: attachment; filename=stress2.dna Content-Type: application/octet-stream; x-mac-type=54455854; x-unix-mode=0644; name="stress2.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##Check for the Database first - create it if not there--[/!] [showif T=[fileinfo file=speed.db][exists][/fileinfo]] [closedatabase db=speed.db] [deletefile file=speed.db] [/showif] [showif F=[fileinfo file=speed.db][exists][/fileinfo]] [writefile file=speed.db]skuvalue [/writefile] [/showif] [!] ##Delete the records in the DB to ensure the search is 'clean'--[/!] [delete db=speed.db&neSKUdata=find_all]                      
(seconds) This Task
 
 
Open a database (2 fields), append 10000 records [Math time]{[time]}-{[start_time]}[/Math]
Show the records [search db=speed.db&neSKUdata=find_all] [founditems] [index] - [value]
[/founditems] [/search]		[Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-3-501172570 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 - chris On Nov 2, 2011, at 13:38, aaronmichaelmusic@gmail.com wrote: > After spending a lot of time with apache configurations, I'm convinced = it is WebDNA and not my configuration. >=20 > I am down to just one site running now with a clean configuration. I = still get the 'bouncing' database behavior between the actual and = previously cached versions throughout refreshes. >=20 > To illustrate whats going on=85. >=20 > Say I have a screen listing database records and I have a GUI to add = new ones, and I quickly add 3 new ones >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 > new1 > new2 > new3 >=20 >=20 > after a couple refreshes, I get this >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 >=20 >=20 > and even more peculiar, I might get this >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 > new2 >=20 >=20 > I've been able to reproduce this behavior over and over again and with = deleting or modifying records as well. >=20 > If I leave it alone for a few minutes and come back, it seems like it = corrected itself and displays the correct records consistently. Also, = manually flushing the databases works too. >=20 > This is really bizarre, and quite frustrating as well. =20 >=20 >=20 >=20 >=20 >=20 > On Nov 1, 2011, at 5:23 PM, christophe.billiottet@webdna.us wrote: >=20 >>=20 >> On Nov 1, 2011, at 19:08, aaronmichaelmusic@gmail.com wrote: >>=20 >>>>=20 >>>> note this configuration is already out of the WebDNA scope: you = should add one WebDNA.fcgi copy per website. >>> I'm using one copy per site, but I copied and pasted the entire = directory (with .fcgi file and all) to another. =20 >>=20 >> and did you setup httpd.conf accordingly? for instance (just an = example) for an OSX server >> you would just have to add one line for each new site to the main = httpd.conf block: >>=20 >> >> FastCGIServer = /Library/WebServer/Documents/testosx1.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> Action webdna-fastcgi /WebDNA/WebDNA.fcgi >> AddHandler webdna-fastcgi .dna >> FastCGIServer = /Library/WebServer/Documents/testosx2.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> >>=20 >>=20 >> And if you had a 3rd one, you'd add: >> FastCGIServer = /Library/WebServer/Documents/testosx3.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> and so forth. >>=20 >> Otherwise, a single copy of WebDNA.fcgi is handling all your = websites... >>=20 >>=20 >> - chris--------------------------------------------------------- >> 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 >=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 --Apple-Mail-3-501172570-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
--Apple-Mail-3-501172570 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Just setup a small test: this adds 10,000 records to a small database = and immediately read them in the same file: it is instantaneous on my = WebDNA 7 test server. --Apple-Mail-3-501172570 Content-Disposition: attachment; filename=stress2.dna Content-Type: application/octet-stream; x-mac-type=54455854; x-unix-mode=0644; name="stress2.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##Check for the Database first - create it if not there--[/!] [showif T=[fileinfo file=speed.db][exists][/fileinfo]] [closedatabase db=speed.db] [deletefile file=speed.db] [/showif] [showif F=[fileinfo file=speed.db][exists][/fileinfo]] [writefile file=speed.db]skuvalue [/writefile] [/showif] [!] ##Delete the records in the DB to ensure the search is 'clean'--[/!] [delete db=speed.db&neSKUdata=find_all]                      
(seconds) This Task
 
 
Open a database (2 fields), append 10000 records [Math time]{[time]}-{[start_time]}[/Math]
Show the records [search db=speed.db&neSKUdata=find_all] [founditems] [index] - [value]
[/founditems] [/search]		[Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-3-501172570 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 - chris On Nov 2, 2011, at 13:38, aaronmichaelmusic@gmail.com wrote: > After spending a lot of time with apache configurations, I'm convinced = it is WebDNA and not my configuration. >=20 > I am down to just one site running now with a clean configuration. I = still get the 'bouncing' database behavior between the actual and = previously cached versions throughout refreshes. >=20 > To illustrate whats going on=85. >=20 > Say I have a screen listing database records and I have a GUI to add = new ones, and I quickly add 3 new ones >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 > new1 > new2 > new3 >=20 >=20 > after a couple refreshes, I get this >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 >=20 >=20 > and even more peculiar, I might get this >=20 > records > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > old1 > old2 > old3 > new2 >=20 >=20 > I've been able to reproduce this behavior over and over again and with = deleting or modifying records as well. >=20 > If I leave it alone for a few minutes and come back, it seems like it = corrected itself and displays the correct records consistently. Also, = manually flushing the databases works too. >=20 > This is really bizarre, and quite frustrating as well. =20 >=20 >=20 >=20 >=20 >=20 > On Nov 1, 2011, at 5:23 PM, christophe.billiottet@webdna.us wrote: >=20 >>=20 >> On Nov 1, 2011, at 19:08, aaronmichaelmusic@gmail.com wrote: >>=20 >>>>=20 >>>> note this configuration is already out of the WebDNA scope: you = should add one WebDNA.fcgi copy per website. >>> I'm using one copy per site, but I copied and pasted the entire = directory (with .fcgi file and all) to another. =20 >>=20 >> and did you setup httpd.conf accordingly? for instance (just an = example) for an OSX server >> you would just have to add one line for each new site to the main = httpd.conf block: >>=20 >> >> FastCGIServer = /Library/WebServer/Documents/testosx1.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> Action webdna-fastcgi /WebDNA/WebDNA.fcgi >> AddHandler webdna-fastcgi .dna >> FastCGIServer = /Library/WebServer/Documents/testosx2.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> >>=20 >>=20 >> And if you had a 3rd one, you'd add: >> FastCGIServer = /Library/WebServer/Documents/testosx3.domain.net/WebDNA/WebDNA.fcgi = -idle-timeout 60 -processes 1 >> and so forth. >>=20 >> Otherwise, a single copy of WebDNA.fcgi is handling all your = websites... >>=20 >>=20 >> - chris--------------------------------------------------------- >> 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 >=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 --Apple-Mail-3-501172570-- 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:

WebCat2b12 - New features for 1.6 users ... (1997) Error: Too many nested [xxx] contexts (1997) nude virgin confusion?? (2004) select multiple (1997) Displaying photo attached to first record (1997) Variables for chat (1997) Virtual hosting and webcatNT (1997) Emailer connect failure definitions (2003) New Command prefs ... (1997) error (2000) Hideif on IP range (2004) RE: Credit card processing - UK (1997) Database flushing does not work any more... (2000) Re1000001: Setting up shop (1997) [quantity] within formulas (1997) Search Engine questions ... (2002) Mozilla/4. and Browser Info.txt (1997) multi-paragraph fields (1997) New index for docs (1997) Include Troubles (1998)