Re: [WebDNA] Seriously what is wrong here?

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107641
interpreted = N
texte = --Apple-Mail-17-590641822 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii So far, i find the website peru.kazwebworks.com working fine for me. Is = there an URL where we could test the problem you mention? Also, you should add .html and .htm to > > AddType text/html .tpl .dna > Can you add this file to your website? --Apple-Mail-17-590641822 Content-Disposition: attachment; filename=stress2.dna Content-Type: application/octet-stream; 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-17-590641822 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 - chris On Nov 3, 2011, at 17:00, aaronmichaelmusic@gmail.com wrote: > Alright, I just rebuilt my VPS, still have the same problem with = bizarre database behavior. >=20 > These were my steps... >=20 > *Rebuild Server =3D Ubuntu 10.04 LTS 64bit > *Installed =3D mysql-server apache2 php5 libapache2-mod-fcgid > * enabled rewrite and fcgid modules > * create virtual host with the following configuration.. >=20 > > ServerAdmin webmaster@localhost > ServerName peru.kazwebworks.com > ServerAlias peru.kazwebworks.com >=20 > DocumentRoot /var/www/peru.kazwebworks.com >=20 > > Options FollowSymLinks > AllowOverride All > DirectoryIndex index.dna index.html index.tpl > >=20 > > deny from all > >=20 > > deny from all > > >=20 > *unzipped WebDNA Archive.zip into /var/www/peru.kazwebworks.com > *chmod 775 to WebDNA.fcgi, then moved into WebDNA folder > *UNIX user in webdna.ini is www-data > *created .htaccess file=85. >=20 > > AddType text/html .tpl .dna > >=20 > Options +ExecCGI > AddHandler fcgid-script .dna .tpl .htm .html >=20 >=20 > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .tpl > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .dna > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .htm > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .html >=20 > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > >=20 > *chown www-data:www-data to entire directory > *enabled vhost peru.kazwebworks.com > *configured Admin prefs from peru.kazwebworks.com/WebDNA/Admin/ > *uploaded GUI database admin, preloaded with dbs > *went to system backend (GUI database admin) to test a db (test.db). > *deleted all records in test.db > *created 3 new records > *refreshed search+founditems screen - got different results throughout = refreshes (showing deleted records+new records, new records only, and = old records only) >=20 >=20 >=20 > I just don't get it, what is wrong here? >=20 >=20 >=20 >=20 > On Nov 3, 2011, at 2:22 PM, aaronmichaelmusic@gmail.com wrote: >=20 >> Same thing as yesterday=85 >>=20 >> After modifying a database, search+founditems randomly presents = different versions of the database from memory. >>=20 >> Chris suggested that multiple instances of WebDNA.fcgi trying to = access the same db is the cause. I removed everything completely and = started with a fresh WebDNA folder and .fcgi. At first I thought it was = fixed and the problem showed up again today. >>=20 >> I'm rebuilding the VPS right now, giving it one more shot. >>=20 >>=20 >>=20 >> On Nov 3, 2011, at 2:12 PM, Kenneth Grome wrote: >>=20 >>> What seems to be the problem? >>>=20 >>> Sincerely, >>> Kenneth Grome >>>=20 >>>=20 >>>=20 >>>> Despite all my best efforts, the performance of WebDNA 7 >>>> on my machine is f*cked. Whoever has a WebDNA 7 server >>>> in production, what distro and web server are you using? >>>>=20 >>>>=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 >>> --------------------------------------------------------- >>> 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 >=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-17-590641822-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Seriously what is wrong here? (Stuart Tremain 2011)
  2. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  3. Re: [WebDNA] Seriously what is wrong here? (Stuart Tremain 2011)
  4. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  5. Re: [WebDNA] Seriously what is wrong here? (Govinda 2011)
  6. Re: [WebDNA] Seriously what is wrong here? (frank@cwolfe.com 2011)
  7. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  8. Re: [WebDNA] Seriously what is wrong here? (Matthew Bohne 2011)
  9. Re: [WebDNA] Seriously what is wrong here? (Govinda 2011)
  10. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  11. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  12. Re: [WebDNA] Seriously what is wrong here? (christophe.billiottet@webdna.us 2011)
  13. Re: [WebDNA] Seriously what is wrong here? (christophe.billiottet@webdna.us 2011)
  14. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  15. Re: [WebDNA] Seriously what is wrong here? (christophe.billiottet@webdna.us 2011)
  16. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  17. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  18. Re: [WebDNA] Seriously what is wrong here? (Govinda 2011)
  19. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  20. Re: [WebDNA] Seriously what is wrong here? (Govinda 2011)
  21. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  22. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  23. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  24. Re: [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
  25. Re: [WebDNA] Seriously what is wrong here? (Kenneth Grome 2011)
  26. Re: [WebDNA] Seriously what is wrong here? (christophe.billiottet@webdna.us 2011)
  27. [WebDNA] Seriously what is wrong here? (aaronmichaelmusic@gmail.com 2011)
--Apple-Mail-17-590641822 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii So far, i find the website peru.kazwebworks.com working fine for me. Is = there an URL where we could test the problem you mention? Also, you should add .html and .htm to > > AddType text/html .tpl .dna > Can you add this file to your website? --Apple-Mail-17-590641822 Content-Disposition: attachment; filename=stress2.dna Content-Type: application/octet-stream; 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-17-590641822 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 - chris On Nov 3, 2011, at 17:00, aaronmichaelmusic@gmail.com wrote: > Alright, I just rebuilt my VPS, still have the same problem with = bizarre database behavior. >=20 > These were my steps... >=20 > *Rebuild Server =3D Ubuntu 10.04 LTS 64bit > *Installed =3D mysql-server apache2 php5 libapache2-mod-fcgid > * enabled rewrite and fcgid modules > * create virtual host with the following configuration.. >=20 > > ServerAdmin webmaster@localhost > ServerName peru.kazwebworks.com > ServerAlias peru.kazwebworks.com >=20 > DocumentRoot /var/www/peru.kazwebworks.com >=20 > > Options FollowSymLinks > AllowOverride All > DirectoryIndex index.dna index.html index.tpl > >=20 > > deny from all > >=20 > > deny from all > > >=20 > *unzipped WebDNA Archive.zip into /var/www/peru.kazwebworks.com > *chmod 775 to WebDNA.fcgi, then moved into WebDNA folder > *UNIX user in webdna.ini is www-data > *created .htaccess file=85. >=20 > > AddType text/html .tpl .dna > >=20 > Options +ExecCGI > AddHandler fcgid-script .dna .tpl .htm .html >=20 >=20 > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .tpl > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .dna > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .htm > FCGIWrapper /var/www/peru.kazwebworks.com/WebDNA/WebDNA.fcgi .html >=20 > > RewriteEngine on > RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] > >=20 > *chown www-data:www-data to entire directory > *enabled vhost peru.kazwebworks.com > *configured Admin prefs from peru.kazwebworks.com/WebDNA/Admin/ > *uploaded GUI database admin, preloaded with dbs > *went to system backend (GUI database admin) to test a db (test.db). > *deleted all records in test.db > *created 3 new records > *refreshed search+founditems screen - got different results throughout = refreshes (showing deleted records+new records, new records only, and = old records only) >=20 >=20 >=20 > I just don't get it, what is wrong here? >=20 >=20 >=20 >=20 > On Nov 3, 2011, at 2:22 PM, aaronmichaelmusic@gmail.com wrote: >=20 >> Same thing as yesterday=85 >>=20 >> After modifying a database, search+founditems randomly presents = different versions of the database from memory. >>=20 >> Chris suggested that multiple instances of WebDNA.fcgi trying to = access the same db is the cause. I removed everything completely and = started with a fresh WebDNA folder and .fcgi. At first I thought it was = fixed and the problem showed up again today. >>=20 >> I'm rebuilding the VPS right now, giving it one more shot. >>=20 >>=20 >>=20 >> On Nov 3, 2011, at 2:12 PM, Kenneth Grome wrote: >>=20 >>> What seems to be the problem? >>>=20 >>> Sincerely, >>> Kenneth Grome >>>=20 >>>=20 >>>=20 >>>> Despite all my best efforts, the performance of WebDNA 7 >>>> on my machine is f*cked. Whoever has a WebDNA 7 server >>>> in production, what distro and web server are you using? >>>>=20 >>>>=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 >>> --------------------------------------------------------- >>> 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 >=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-17-590641822-- 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:

Snake Bites (1997) Bug Report, maybe (1997) (OT) Dual 2GHz G5 (2003) Cart Numbers (1997) WebCatalog can't find database (1997) How true is this? (1999) Webcatalog Future?!? (2000) Max Record length (1997) RE: [input] questions (1997) Version f1 status (1997) OT: Several requests (2003) Shorthand for command args (1998) Webcat & SIMS (1998) Post arguments problem mac? (1997) WCS Newbie question (1997) WebCat2 beta 11 - new prefs ... (1997) Using files in an Email broadcast (1999) WebCommerce: Folder organization ? (1997) all records returned. (1997) emailer on Windows Beta 18 (1997)