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:

multi-paragraph fields (1997) PSC recommends what date format yr 2000??? (1997) PCS Emailer's role ? (1997) Webcat 3.0.5b9, b8 trigger failures ON WEBSTAR (1999) Some Questions (1997) WebCatalog 2.0 b 15 mac (1997) can WC render sites out? (1997) Updating shipcost (2005) WebCat 3? (2000) URL for Discussion Archive (1997) Progress !! WAS: Trouble with formula.db (1997) quick [middle] Q (2000) Deleting Orders (1997) Loosing Quantity (2000) question: webmerchant connection (1997) [delete] problem (1997) [offtopic]P1: How to make webcatalog more stable. - LONG (1999) WebCat2b13MacPlugIn - [include] (1997) Browser Reloads and AddlineItem (1997) WebCatalog for Postcards ? (1997)