RE: [WebDNA] [AddFields] Restrictions
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108747
interpreted = N
texte = I understand the financial limitations. If it helps, I use the addFields for a .hdr file. Does that make a difference? -----Original Message----- From: christophe.billiottet@webdna.us [mailto:christophe.billiottet@webdna.us] Sent: Wednesday, February 29, 2012 6:21 PM To: talk@webdna.us Subject: Re: [WebDNA] [AddFields] Restrictions So far, it seems the columns limit has been added in 5.1 because of previous problems with this context. WebDNA has to calculate how big the new buffer needs to be to fit all the old data and the new, allocate the memory that will hold the new DB, then get pointer to the old and new buffers so that it can traverse both to copy the old data into the new buffer, increment the field count, free the old buffer, and set the field pointer to point to the new buffer. It will then copy the data to disk, reload the entire contents of the database into RAM, to give subclasses a chance to clean up and reinitialize properly. It is a more complicated process than it looks... If we remove the limit, it will be necessary to rewrite parts of WebDNA: this would be a costly process. I am afraid we will keep this as it is for now... - chris On Feb 29, 2012, at 20:42, Michael A. DeLorenzo wrote: > Chris, > > If there is no reason to limit it then why do so? Is there a reason? > If not, then yes, it would be nice to be able to add a larger number > of fields to a database. It would be specifically helpful when > importing data from other programs on the fly....I currently have to > import a database file from another program, rename all of the field > names and create a new database on a subset of the data. The ability > to add multiple fields at once would help a lot. > > Mike > > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us] > Sent: Wednesday, February 29, 2012 4:55 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [AddFields] Restrictions > > Hi Mike! no, we did not change this behaviour. We did not consider it > as a bug, but a small limitation documented at > http://www.webdna.us/page.dna?numero=195 > > Columns could be added 4 at a time in consecutive operations without > adding much work. > > However, if there is a serious reason to modify this, we will do it. > > - chris > > > > On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: > >> It's been a while but I need to know if the AddFields bug has been >> fixed. I didn't want to assume.... >> >> Thanks, >> Mike >> >> -----Original Message----- >> From: Donovan Brooke [mailto:dbrooke@webdna.us] >> Sent: Monday, October 13, 2008 6:49 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] [AddFields] Restrictions >> >> Michael A. DeLorenzo wrote: >> >>> Has anyone experienced a limitation on the number of fields that can >>> be added to a database at one time? I'm currently only able to add 4 >>> fields at one time to my database. >> >> >> Looks to me like that tag is a bit buggy... didn't see any >> limitations in the source and some of my tests had odd results (also >> confirming adding only >> 4 fields on a *nix environment.) >> >> So, consider this added to the bug list! Thanks Michael. >> >> Donovan >> >> >> >> -- >> Donovan D. Brooke PH/FAX: 1 (608) 291-2024 >> ---------------------------------------------- >> VP >> WebDNA Software Corporation >> 16192 Coastal Highway >> Lewes, DE 19958 >> --------------------------------------------------------- >> 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 >> old archives: http://dev.webdna.us/TalkListArchive/ >> >> >> >> --------------------------------------------------------- >> 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 > > > > > --------------------------------------------------------- > 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
Associated Messages, from the most recent to the oldest:
I understand the financial limitations. If it helps, I use the addFields for a .hdr file. Does that make a difference? -----Original Message----- From: christophe.billiottet@webdna.us [mailto:christophe.billiottet@webdna.us] Sent: Wednesday, February 29, 2012 6:21 PM To: talk@webdna.us Subject: Re: [WebDNA] [addfields] Restrictions So far, it seems the columns limit has been added in 5.1 because of previous problems with this context. WebDNA has to calculate how big the new buffer needs to be to fit all the old data and the new, allocate the memory that will hold the new DB, then get pointer to the old and new buffers so that it can traverse both to copy the old data into the new buffer, increment the field count, free the old buffer, and set the field pointer to point to the new buffer. It will then copy the data to disk, reload the entire contents of the database into RAM, to give subclasses a chance to clean up and reinitialize properly. It is a more complicated process than it looks... If we remove the limit, it will be necessary to rewrite parts of WebDNA: this would be a costly process. I am afraid we will keep this as it is for now... - chris On Feb 29, 2012, at 20:42, Michael A. DeLorenzo wrote: > Chris, > > If there is no reason to limit it then why do so? Is there a reason? > If not, then yes, it would be nice to be able to add a larger number > of fields to a database. It would be specifically helpful when > importing data from other programs on the fly....I currently have to > import a database file from another program, rename all of the field > names and create a new database on a subset of the data. The ability > to add multiple fields at once would help a lot. > > Mike > > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us] > Sent: Wednesday, February 29, 2012 4:55 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [addfields] Restrictions > > Hi Mike! no, we did not change this behaviour. We did not consider it > as a bug, but a small limitation documented at > http://www.webdna.us/page.dna?numero=195 > > Columns could be added 4 at a time in consecutive operations without > adding much work. > > However, if there is a serious reason to modify this, we will do it. > > - chris > > > > On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: > >> It's been a while but I need to know if the AddFields bug has been >> fixed. I didn't want to assume.... >> >> Thanks, >> Mike >> >> -----Original Message----- >> From: Donovan Brooke [mailto:dbrooke@webdna.us] >> Sent: Monday, October 13, 2008 6:49 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] [addfields] Restrictions >> >> Michael A. DeLorenzo wrote: >> >>> Has anyone experienced a limitation on the number of fields that can >>> be added to a database at one time? I'm currently only able to add 4 >>> fields at one time to my database. >> >> >> Looks to me like that tag is a bit buggy... didn't see any >> limitations in the source and some of my tests had odd results (also >> confirming adding only >> 4 fields on a *nix environment.) >> >> So, consider this added to the bug list! Thanks Michael. >> >> Donovan >> >> >> >> -- >> Donovan D. Brooke PH/FAX: 1 (608) 291-2024 >> ---------------------------------------------- >> VP >> WebDNA Software Corporation >> 16192 Coastal Highway >> Lewes, DE 19958 >> --------------------------------------------------------- >> 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 >> old archives: http://dev.webdna.us/TalkListArchive/ >> >> >> >> --------------------------------------------------------- >> 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 > > > > > --------------------------------------------------------- > 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
"Michael A. DeLorenzo"
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:
thisurl & arguments (2000)
[ShowNext] (1997)
can WC render sites out? (1997)
You know you have made your client successfully when... (2003)
more on quicktime test stuff (1997)
math on date? (1997)
Multiple Items (1998)
New public beta available (1997)
Running 2 two WebCatalog.acgi's (1996)
Sorting Numbers (1997)
[WebDNA] TCPconnect and Bitcoin rate (2017)
Re:2nd WebCatalog2 Feature Request (1996)
Showif, Hideif reverse logic ? (1997)
webcatalog 2.1.3 ACGI Weirdness? (1998)
WebCatb15 Mac CGI -- [purchase] (1997)
New WebCatalog Version !!! (1997)
Frames and cart values (1998)
how to do multiple prices/item? (1998)
hmmm (2006)
Follow-up to listfiles bug report ... (2003)