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:

calculating tax rates, mail order solutions and version 2 (1997) Netscape v. IE (1997) no global [username] or [password] displayed ... (1997) [WebDNA] I can't log into WebDNA (2014) converting tabs (1997) BGcolor (1997) [index] (1997) Imagemagick and fonts (2004) Locking up with WebCatalog... (1997) customizing the color of user's pages (1997) Webcat interfering with Webstar? (1998) ShowNext Command (1997) Sv: Search problems! (1999) Permissions / Restart WebDNA? (2005) update on wn searching (1997) WebCatalog2 Feature Feedback (1996) Misc Stuff That Might Help (1997) Bug or syntax error on my part? (1997) [WebDNA] Using webdna to automate ftp on a Windows server (2012) Share Bulletin Board? (1998)