Re: [WebDNA] [AddFields] Restrictions
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108745
interpreted = N
texte = 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, >=20 > 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.=20 >=20 > Mike >=20 > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us]=20 > Sent: Wednesday, February 29, 2012 4:55 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [AddFields] Restrictions >=20 > 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=3D195 >=20 > Columns could be added 4 at a time in consecutive operations without = adding > much work. >=20 > However, if there is a serious reason to modify this, we will do it. >=20 > - chris >=20 >=20 >=20 > On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: >=20 >> It's been a while but I need to know if the AddFields bug has been=20 >> fixed. I didn't want to assume.... >>=20 >> Thanks, >> Mike >>=20 >> -----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 >>=20 >> Michael A. DeLorenzo wrote: >>=20 >>> Has anyone experienced a limitation on the number of fields that can=20= >>> be added to a database at one time? I'm currently only able to add 4=20= >>> fields at one time to my database. >>=20 >>=20 >> Looks to me like that tag is a bit buggy... didn't see any = limitations=20 >> in the source and some of my tests had odd results (also confirming=20= >> adding only >> 4 fields on a *nix environment.) >>=20 >> So, consider this added to the bug list! Thanks Michael. >>=20 >> Donovan >>=20 >>=20 >>=20 >> --=20 >> 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=20= >> list
. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> 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 >=20 >=20 >=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
Associated Messages, from the most recent to the oldest:
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, >=20 > 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.=20 >=20 > Mike >=20 > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us]=20 > Sent: Wednesday, February 29, 2012 4:55 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [addfields] Restrictions >=20 > 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=3D195 >=20 > Columns could be added 4 at a time in consecutive operations without = adding > much work. >=20 > However, if there is a serious reason to modify this, we will do it. >=20 > - chris >=20 >=20 >=20 > On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: >=20 >> It's been a while but I need to know if the AddFields bug has been=20 >> fixed. I didn't want to assume.... >>=20 >> Thanks, >> Mike >>=20 >> -----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 >>=20 >> Michael A. DeLorenzo wrote: >>=20 >>> Has anyone experienced a limitation on the number of fields that can=20= >>> be added to a database at one time? I'm currently only able to add 4=20= >>> fields at one time to my database. >>=20 >>=20 >> Looks to me like that tag is a bit buggy... didn't see any = limitations=20 >> in the source and some of my tests had odd results (also confirming=20= >> adding only >> 4 fields on a *nix environment.) >>=20 >> So, consider this added to the bug list! Thanks Michael. >>=20 >> Donovan >>=20 >>=20 >>=20 >> --=20 >> 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=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> 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 >=20 >=20 >=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
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:
Extended [ConvertChars] (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
protect tag on NT IIS (1997)
[OT] Domain Management (2003)
Using Cookie for client specific info? (1997)
FREE Web Server Monitor FREE (1997)
bug in [SendMail] (1997)
WebMerchant 1.6 and SHTML (1997)
Carts & Refering URLs (1997)
WebCat2 - many [carts] on one template page? (1997)
RE: Error: template (1997)
OT: Version Control (2007)
Webstar 1.3.1 PPC (1997)
RE: Automatic Forwarding using WebCat (1997)
Multiple catalog databases and showcart (1997)
Web Catalog and Net Cloak (1998)
I try hard to think positively (1998)
[WebDNA] [OT] Apple iPad (2010)
New Mac Emailer... (1997)
Converting Quotes in Javascript (2001)