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:

[WebDNA] To Commitdatabase or Not to Commitdatabase (2012) carriage returns in data (1997) The Guru Speaks-Is That Really the Only Manuel? (1998) New command suggestion (1997) WebCatalog can't find database (1997) WebCatalog can't find database (1997) Append (1999) Almost a there but..bye bye NetCloak (1997) Help! WebCat2 bug (Ben's input) (1997) Anyone awake? Newby moves deeper! Sitesearch & Customer DB (2000) converting characters in form (1997) CMS - Formatting Content (2004) MySQL (2003) 5.0 tips etc (2003) using showpage and showcart commands (1996) Formulas.db / Quantity Discount problem (1998) Nutscrape Doesn't Render Right (2002) [SQL] & ODBC on Mac - Reposted (2000) (1997) SSL, WebSTAR, WebCatalog (1998)