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:

Off Topic - OS X web server, FTP accounts (2003) search / summary (2005) What's the mod_webcatalog2.so.2.0 file for??? (2005) WebCatalog for Mac 2.0.1 Released (1997) no global [username] or [password] displayed ... (1997) return missing item (was:WebCat Sales) (1997) WC2f3 (1997) [input] formating (1998) Slow Code, how to speed up (2002) Shopping Cart Limits? (1998) Weird error/limit - something amiss? (1997) docs for WebCatalog2 (1997) I'm tired of all this! (2000) E-mailer application times out (1998) problems with 2 tags (1997) Webcatalog 2.1* and Personal Web Server 4.0 (1998) Re:Emailer and encryption (1997) [WebDNA] ListMIMEHeaders (2008) forms and variables (1998) Netscape v. IE (1997)