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:
WCS Newbie question (1997)
Document Contains No Data! (1997)
[convertchars] Problem (2000)
Dubble Sku's in a Database (1999)
+ character mystery (2003)
Starting WebCat under linux (2000)
Email Line Breaks (2003)
Autoreturn Submit? (1997)
Limitations on fields? Server is crashing (1997)
Sorting by date (1997)
thankyou.tmpl (1997)
Text data with spaces in them... (1997)
Not really WebCat- (1997)
Error: this shopping cart has already been submitted and (2006)
WebDNA Developer Resource Center (2002)
Server slowing down. (1997)
WebCat2.0 acgi vs plugin (1997)
Error Lob.db records error message not name (1997)
UPS Shipping Docs (Where To Go) (1999)
docs for WebCatalog2 (1997)