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:
TCPConnect to query for Domain expiration (2000)
Replacing a Word (1999)
Math with Time (1997)
supressing math results (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
$Replace with [founditems] (1997)
Tab Charactor (1997)
Wireless WebDNA available today! (2000)
[SHOWIF AND/OR] (1997)
Multiple security dbs (1997)
WebCat2 several catalogs? (1997)
Emailer choke (1997)
b12 cannot limit records returned and more. (1997)
[OT] Appropriate Signature??? (2003)
ConvertChars (2000)
WebCat with WebTen (1998)
Combining search criteria (2000)
RE: [WebDNA] Talklist Archive & Twitter (2009)
PIXO support (1997)
Multiple security dbs (1997)