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...- chrisOn 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...- chrisOn 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:
OT: How to get more traffic to a site? (2005)
Verifying both name and password (was: New Problem) (1997)
mac hack (1997)
[WebDNA] WebDNA 8 (2014)
ShowNext Command (1997)
Sku numbers (1997)
Showif dates... (2002)
PSC recommends what date format yr 2000??? (1997)
[WebDNA] [OT]Dylan - Email prob. (2008)
Um...how do I ask this? (1999)
Workaround for Emailer doubled bcc messages (1998)
date range (1998)
[addlineitems] (1997)
more multiple items to shopping cart (2000)
hideifs using [date] (1999)
How to best sort in a pre-defined item-by-item order ... (2003)
multi-paragraph fields (1997)
different show next (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
PCS Frames (1997)