Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108157
interpreted = N
texte = Hi Chris, Actually I do not use full paths within my code. But when I use a = listdatabases funktion it is viewed with a full path; compared to native = webdna databases like user.db etc. which are shown with relative. Time time spent in the stress test might be affected by the fact that I = have commit databases enabled at all times to see if append/replace is = working. Im still stuck /Palle On 21/01/2012, at 22.39, christophe.billiottet@webdna.us wrote: > If the test works, it means you can write files inside your directory, = so, no permission problems (at least for this directory) >=20 > I understand you use full path from your server root to link your = databases. This is most probably the problem. You should link your = databases from the file that requests access to them. >=20 > About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s = with "Only commit databases to disk when instructed" and 25s with = "Automatically commit databases to disk after modification" >=20 > - chris >=20 >=20 > On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote: >=20 >> Hi Chris, >>=20 >> No error messages from WebDNA and I am quite sure my paths are = correct. The only place where I could be a bit unsure is my virtual = config... anyone care to validate (code below form my = httpd-vhosts.conf)... >>=20 >>=20 >> ---- >>=20 >>=20 >> And the results... >>=20 >> Variables >> Text Variables - Set an increasing # into a text variable 10000 times >> 00:00:05 >> Let's do some math: sin(x), 0> 00:00:00 >>=20 >> Database Manipulation >> Open a database (2 fields), append 10000 records00:00:02 >> Now 40000 searches with [lookup]00:00:02 >> 10000 searches with [search]00:00:18 >> Delete the records00:00:06 >>=20 >> ------ >>=20 >>=20 >>=20 >>=20 >> NameVirtualHost *:80 >>=20 >> >> ServerAdmin xxx@xxx.dk >> DocumentRoot /Library/WebServer/Documents/www.macnyt.dk >> ServerName macnyt.dk >> ServerAlias www.macnyt.dk >> DirectoryIndex index.html index.dna index.tpl default.tpl >> ErrorLog /private/var/log/apache2/a.macnyt-error_log >> CustomLog /private/var/log/apache2/a.macnyt-access_log common >>=20 >> #----------------------- >> >> RewriteEngine on >> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] >> >> #----------------------- >>=20 >> >>=20 >> >> ServerAdmin xxx@xxx.dk >> DocumentRoot /Library/WebServer/Documents/b.qt.dk >> ServerName qt.dk >> ServerAlias b.qt.dk >> DirectoryIndex index.html index.dna index.tpl >> ErrorLog /private/var/log/apache2/b.qt.dk-error_log >> CustomLog /private/var/log/apache2/b.qt-access_log common >>=20 >> #----------------------- >> >> RewriteEngine on >> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] >> >> #----------------------- >>=20 >> >>=20 >>=20 >>=20 >>=20 >> On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: >>=20 >>> Hi Palle! does WebDNA returns an error message? are your paths = correct? is the folder that contains your database has proper = permissions? >>>=20 >>> Try to run this small speed test >>>=20 >>> >>>=20 >>> It writes a new database, appends 10,000 records and search it via = lookup and search, then deletes the records. Play with the preferences = "Only commit databases to disk when instructed" and "Automatically = commit databases to disk after modification" to see the differences. >>>=20 >>> - chris >>>=20 >>> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: >>>=20 >>>> Ho all, >>>>=20 >>>> I have just migrated a site from a v6.2 server to a v7 server. = Until now everything seems to work just fine and that positive. >>>>=20 >>>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within = WebDNA, the DB's are changes accordingly. But when I change any of my = own DB's with my site code nothing happens; at all !!! >>>>=20 >>>> Could this be a misconfiguration of some kind like within the = http-vhost.conf or any where else? I am a bit puzzled and a bit tired = (read: confused). >>>>=20 >>>> Any help or push in a right direction would be sooooo nice right = now... >>>>=20 >>>> By the way. WebDNA databases and my own databases has the same = rights... >>>>=20 >>>> /Palle--------------------------------------------------------- >>>> 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 >=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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  2. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  3. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  4. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  5. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  6. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Govinda 2012)
  7. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  8. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  9. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  10. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (christophe.billiottet@webdna.us 2012)
  11. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  12. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
  13. Re: [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Govinda 2012)
  14. [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (Palle Bo Nielsen 2012)
Hi Chris, Actually I do not use full paths within my code. But when I use a = listdatabases funktion it is viewed with a full path; compared to native = webdna databases like user.db etc. which are shown with relative. Time time spent in the stress test might be affected by the fact that I = have commit databases enabled at all times to see if append/replace is = working. Im still stuck /Palle On 21/01/2012, at 22.39, christophe.billiottet@webdna.us wrote: > If the test works, it means you can write files inside your directory, = so, no permission problems (at least for this directory) >=20 > I understand you use full path from your server root to link your = databases. This is most probably the problem. You should link your = databases from the file that requests access to them. >=20 > About the test, your total is 33 seconds. A Mac Mini core i7 takes 20s = with "Only commit databases to disk when instructed" and 25s with = "Automatically commit databases to disk after modification" >=20 > - chris >=20 >=20 > On Jan 21, 2012, at 19:26, Palle Bo Nielsen wrote: >=20 >> Hi Chris, >>=20 >> No error messages from WebDNA and I am quite sure my paths are = correct. The only place where I could be a bit unsure is my virtual = config... anyone care to validate (code below form my = httpd-vhosts.conf)... >>=20 >>=20 >> ---- >>=20 >>=20 >> And the results... >>=20 >> Variables >> Text Variables - Set an increasing # into a text variable 10000 times >> 00:00:05 >> Let's do some math: sin(x), 0> 00:00:00 >>=20 >> Database Manipulation >> Open a database (2 fields), append 10000 records00:00:02 >> Now 40000 searches with [lookup]00:00:02 >> 10000 searches with [search]00:00:18 >> Delete the records00:00:06 >>=20 >> ------ >>=20 >>=20 >>=20 >>=20 >> NameVirtualHost *:80 >>=20 >> >> ServerAdmin xxx@xxx.dk >> DocumentRoot /Library/WebServer/Documents/www.macnyt.dk >> ServerName macnyt.dk >> ServerAlias www.macnyt.dk >> DirectoryIndex index.html index.dna index.tpl default.tpl >> ErrorLog /private/var/log/apache2/a.macnyt-error_log >> CustomLog /private/var/log/apache2/a.macnyt-access_log common >>=20 >> #----------------------- >> >> RewriteEngine on >> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] >> >> #----------------------- >>=20 >> >>=20 >> >> ServerAdmin xxx@xxx.dk >> DocumentRoot /Library/WebServer/Documents/b.qt.dk >> ServerName qt.dk >> ServerAlias b.qt.dk >> DirectoryIndex index.html index.dna index.tpl >> ErrorLog /private/var/log/apache2/b.qt.dk-error_log >> CustomLog /private/var/log/apache2/b.qt-access_log common >>=20 >> #----------------------- >> >> RewriteEngine on >> RewriteRule .* - [E=3DHTTP_AUTHORIZATION:%{HTTP:Authorization},L] >> >> #----------------------- >>=20 >> >>=20 >>=20 >>=20 >>=20 >> On 21/01/2012, at 22.05, christophe.billiottet@webdna.us wrote: >>=20 >>> Hi Palle! does WebDNA returns an error message? are your paths = correct? is the folder that contains your database has proper = permissions? >>>=20 >>> Try to run this small speed test >>>=20 >>> >>>=20 >>> It writes a new database, appends 10,000 records and search it via = lookup and search, then deletes the records. Play with the preferences = "Only commit databases to disk when instructed" and "Automatically = commit databases to disk after modification" to see the differences. >>>=20 >>> - chris >>>=20 >>> On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: >>>=20 >>>> Ho all, >>>>=20 >>>> I have just migrated a site from a v6.2 server to a v7 server. = Until now everything seems to work just fine and that positive. >>>>=20 >>>> When I use ...webdna/Admin/AdminPrefs.dna and change setting within = WebDNA, the DB's are changes accordingly. But when I change any of my = own DB's with my site code nothing happens; at all !!! >>>>=20 >>>> Could this be a misconfiguration of some kind like within the = http-vhost.conf or any where else? I am a bit puzzled and a bit tired = (read: confused). >>>>=20 >>>> Any help or push in a right direction would be sooooo nice right = now... >>>>=20 >>>> By the way. WebDNA databases and my own databases has the same = rights... >>>>=20 >>>> /Palle--------------------------------------------------------- >>>> 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 >=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 Palle Bo Nielsen

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:

emailer (1997) Sorting by date (1997) WebCat b13 CGI -shownext- (1997) New public beta available (1997) Hosts who have upgraded to v5.0? (2003) Price lookup problem - was Cart questions (1997) garbage on page (2000) Multiple Unique SKUs (2000) WC2.0 Memory Requirements (1997) WebCatalog can't find database (1997) Browser frames and URLs in the Location field (2004) Help name our technology! (1997) Web Logs (1998) Requiring that certain fields be completed (1997) text conversions (1999) So [OT] it's not even funny (2003) searching multiple databases (1997) Problems getting parameters passed into email. (1997) error: Too many nested [xxx] contexts (1997) searchable list archive (1997)