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 = 108150
interpreted = N
texte = --Apple-Mail-10-980385958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Palle! does WebDNA returns an error message? are your paths correct? = is the folder that contains your database has proper permissions? Try to run this small speed test --Apple-Mail-10-980385958 Content-Disposition: attachment; filename=stressfull.dna Content-Type: application/octet-stream; name="stressfull.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
 
 
Variables
Text Variables - Set an increasing # into a text variable 10000 times
		[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.
		[Math time]{[time]}-{[start_time]}[/Math]
 
Database Manipulation
Open a database (2 fields), append 10000 records [Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw] [Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw] [Math time]{[time]}-{[start_time]}[/Math]
Delete the records [Math time]{[time]}-{[start_time]}[/Math]
Open a database (2 fields), append 10000 records using the replace trick [Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-10-980385958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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. - chris On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: > 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 --Apple-Mail-10-980385958-- 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)
--Apple-Mail-10-980385958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Palle! does WebDNA returns an error message? are your paths correct? = is the folder that contains your database has proper permissions? Try to run this small speed test --Apple-Mail-10-980385958 Content-Disposition: attachment; filename=stressfull.dna Content-Type: application/octet-stream; name="stressfull.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
 
 
Variables
Text Variables - Set an increasing # into a text variable 10000 times
		[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.
		[Math time]{[time]}-{[start_time]}[/Math]
 
Database Manipulation
Open a database (2 fields), append 10000 records [Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw] [Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw] [Math time]{[time]}-{[start_time]}[/Math]
Delete the records [Math time]{[time]}-{[start_time]}[/Math]
Open a database (2 fields), append 10000 records using the replace trick [Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-10-980385958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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. - chris On Jan 21, 2012, at 16:36, Palle Bo Nielsen wrote: > 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 --Apple-Mail-10-980385958-- 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:

Help with getting rpm file (2002) Pricing (1998) Banners and sort of random display (1997) Spawn not working (1999) Locking up with WebCatalog... (1997) Exclamation point (1997) Reversed words (1997) New Command prefs ... (1997) getchars broken? (1997) WebCatalog Work (2001) Problems with [Applescript] (1997) [WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012) [WebDNA] find missing file in [listfiles] (2019) How to get shownext to just shownext once (1997) Some Questions (1997) [WebDNA] V8.6 FCGI (2018) Seattle based Webcatters? (2000) Showif Error Generated... (2003) Re:Comments Convertion-part2 (1998) [WebDNA] sales tax on shipping (2008)