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:

customer info (2001) Quick ShowIf question (1997) webcat serving up 2+ versions of the same db? (2000) RFE: grep is really pathetic sometimes (2003) forms and variables (1998) 3.0 [TEXT] variables (1998) help with autenticate (1998) WebCat2b15MacPlugin - [protect] (1997) Bug Report, maybe (1997) Simple way to create unique SKU (1997) suggestions (1998) headers (2000) WebCat2b12 CGI Mac - [shownext] problem (1997) [WebDNA] Downloadable file protection (2011) Sorting by date (1997) RAM variables (1997) unique ascending numbers (2003) Shopping carts and reloading pages (1997) [WebDNA] PDF creation (2013) Help w/Multi User Admins (1997)