Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 110047
interpreted = N
texte = --Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Donovan, You are right on all your assumptions and the reason to use Array is = basically for me to get familiar with the functionality within WebDNA = but also because - and as you wrote "...once the data set i loaded into = your array, actual references to it would be fast..." and this is spot = on inside my Forum project. Anyhow; your Table-to-Array alternative might be the right solution. = Using a DB or a Table might be second priority. ... and thank you very much for your (and speedy) feedback. /Palle On 19/12/2012, at 19.02, Donovan Brooke wrote: > If you have a multi-dimensional array, where one of the dimensions has = a "[DimSize_]" of > over a billion, I would think that is going to be unwieldy and = probably not the solution you are really looking for. >=20 > If you post the code that you are trying to use, I may be able to = better understand what you are trying to do... >=20 > However, I'm guessing that you are only creating that large of an = array because you need one of the dimensions to > to match a cart number... (which leaves a *lot* of wasted cells).=20 >=20 > (in that case, I'd probably create a database or table for a keyed = reference to the cart).. ie: >=20 > keyed.db > ------------------------------------------ > kCartkCartID > 1000000123531 > 1000000104532 > ------------------------------------------ >=20 > # Find num records > [text]t_numcarts=3D[search = db=3Dkeyed.db&nekCartdatarq=3Dfind_all][numfound][/search][/text] >=20 > # Then you could create a much smaller array: > [arrayset name=3Dyourarray&dim=3D[t_numcarts],2,2][/arrayset] >=20 > # Populate your Array however you like (I'm just populating values for = the example): > [text]t_Cart=3D[lookup = db=3Dkeyed.db&value=3D[cartReference]&lookinfield=3D[kCart]&returnfield=3D= kCartID][/text] > [arrayset = name=3Dyourarray]([t_Cart],1,2)=3DTo&([t_Cart],2,1)=3DDonovan[/arrayset] >=20 > # To display: (remember, [t_Cart] =3D '1') > [yourarray([t_Cart],1,2)] (parses to 'To") > [yourarray([t_Cart],2,1)] (parses to 'Donovan') >=20 >=20 >=20 > Anyway, the only possible benefit of doing it this way, instead of = just using a table or database is that once > the data set is loaded into your array, actual references to it would = be fast. Otherwise, just use a table or=20 > .db I guess. >=20 > (this is all assuming I'm understanding your question) ;-) > Donovan >=20 > =20 > =20 > On Wednesday 19/12/2012 at 9:57 am, Palle Bo Nielsen wrote: >> Well, you are right I would like to create a lot of cells but not all = of them to be utilized. >>=20 >> Let me try to explain. I want to be able to use any cell from 0 to = a-very-big-number, but not all cells will be utilized; only very = specific numbers (cells) based on cart values which in the other = dimensions related to specific content in those cells. >>=20 >> Dim CART, A VALUE, A STRING >>=20 >> 10000001235301Hello >> 10000001045301To >> 10000001045310Donovan >>=20 >> In this case I can find a CART and very easily display any of the = other cells. >>=20 >> So baseline is that I do not need ALL billions of cell's, only = selected. >>=20 >> Does it make sense? >>=20 >> /Palle >>=20 >>=20 >> On 19/12/2012, at 01.38, Donovan Brooke wrote: >>=20 >>> Donovan Brooke wrote: >>>> You are trying to create an array with (likely over) 1 billion = dimensions? >>>=20 >>>=20 >>> What I meant to say Palle is that it appears you are trying to = create an array with at least or over 1B cells. I've never created an = array that large, and I would guess you are running into RAM issues = perhaps?? >>>=20 >>> Maybe post your code? >>>=20 >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> --=20 >>> Donovan Brooke >>> WebDNA Software Corporation >>> http://www.webdna.us >>> **[Square Bracket Utopia]** >>> --------------------------------------------------------- >>> 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 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- 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 --Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi = Donovan,

You are right on all your assumptions and = the reason to use Array is basically for me to get familiar with the = functionality within WebDNA but also because - and as you wrote "...once = the data set i loaded into your array, actual references to it would be = fast..." and this is spot on inside my Forum = project.

Anyhow; your Table-to-Array = alternative might be the right solution. Using a DB or a Table might be = second priority.

... and thank you very much = for your (and speedy) = feedback.

/Palle



On 19/12/2012, at 19.02, Donovan Brooke <dbrooke@webdna.us> = wrote:

If = you have a multi-dimensional array, where one of the dimensions has a = "[DimSize_]" of
over a billion, I would think that is going to be = unwieldy and probably not the solution you are really looking = for.

If you post the code that you are trying to use, I may be = able to better understand what you are trying to do...

However, = I'm guessing that you are only creating that large of an array because = you need one of the dimensions to
to match a cart number... (which = leaves a *lot* of wasted cells). 

(in that case, I'd = probably create a database or table for a keyed reference to the cart).. = ie:

keyed.db
------------------------------------------
kCart= <tab>kCartID
100000012353<tab>1
100000010453<tab>2=
------------------------------------------

# Find num = records
[text]t_numcarts=3D[search = db=3Dkeyed.db&nekCartdatarq=3Dfind_all][numfound][/search][/text]
<= br># Then you could create a much smaller array:
[arrayset = name=3Dyourarray&dim=3D[t_numcarts],2,2][/arrayset]

# = Populate your Array however you like (I'm just populating values for the = example):
[text]t_Cart=3D[lookup = db=3Dkeyed.db&value=3D[cartReference]&lookinfield=3D[kCart]&re= turnfield=3DkCartID][/text]
[arrayset = name=3Dyourarray]([t_Cart],1,2)=3DTo&([t_Cart],2,1)=3DDonovan[/arrayse= t]

# To display: (remember, [t_Cart] =3D = '1')
[yourarray([t_Cart],1,2)]  (parses to = 'To")
[yourarray([t_Cart],2,1)]  (parses to = 'Donovan')



Anyway, the only possible benefit of doing it = this way, instead of just using a table or database is that once
the = data set is loaded into your array, actual references to it would be = fast. Otherwise, just use a table or 
.db I = guess.

(this is all assuming I'm understanding your question) = ;-)
Donovan

 
 
On Wednesday 19/12/2012 at 9:57 am, = Palle Bo Nielsen wrote:
Well, you are right I would like to create a lot of = cells but not all of them to be utilized.

Let me try to explain. = I want to be able to use any cell from 0 to a-very-big-number, but not = all cells will be utilized; only very specific numbers (cells) based on = cart values which in the other dimensions related to specific content in = those cells.

Dim CART, A VALUE, A STRING

100000012353= 01Hello
10000001045301= To
10000001045310Donovan

In this case I = can find a CART and very easily display any of the other = cells.

So baseline is that I do not need ALL billions of cell's, = only selected.

Does it make sense?

/Palle


On = 19/12/2012, at 01.38, Donovan Brooke <dbrooke@webdna.us> = wrote:

Donovan = Brooke wrote:
You are = trying to create an array with (likely over) 1 billion = dimensions?


What I meant to say Palle is that it = appears you are trying to create an array with at least or over 1B = cells. I've never created an array that large, and I would guess you are = running into RAM issues perhaps??

Maybe post your = code?


Donovan





-- 
Donovan = Brooke
WebDNA Software Corporation
http://www.webdna.us
**[Square = Bracket = Utopia]**
---------------------------------------------------------
= This message is sent to you because you are subscribed to
the mailing = list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us
---------------------------------------------------------
This = message is sent to you because you are subscribed to
the mailing list = <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/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: archive= s: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
  2. Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
  3. Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
  4. Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
  5. Re: [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Donovan Brooke 2012)
  6. [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (Palle Bo Nielsen 2012)
--Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Donovan, You are right on all your assumptions and the reason to use Array is = basically for me to get familiar with the functionality within WebDNA = but also because - and as you wrote "...once the data set i loaded into = your array, actual references to it would be fast..." and this is spot = on inside my Forum project. Anyhow; your Table-to-Array alternative might be the right solution. = Using a DB or a Table might be second priority. ... and thank you very much for your (and speedy) feedback. /Palle On 19/12/2012, at 19.02, Donovan Brooke wrote: > If you have a multi-dimensional array, where one of the dimensions has = a "[DimSize_]" of > over a billion, I would think that is going to be unwieldy and = probably not the solution you are really looking for. >=20 > If you post the code that you are trying to use, I may be able to = better understand what you are trying to do... >=20 > However, I'm guessing that you are only creating that large of an = array because you need one of the dimensions to > to match a cart number... (which leaves a *lot* of wasted cells).=20 >=20 > (in that case, I'd probably create a database or table for a keyed = reference to the cart).. ie: >=20 > keyed.db > ------------------------------------------ > kCartkCartID > 1000000123531 > 1000000104532 > ------------------------------------------ >=20 > # Find num records > [text]t_numcarts=3D[search = db=3Dkeyed.db&nekCartdatarq=3Dfind_all][numfound][/search][/text] >=20 > # Then you could create a much smaller array: > [arrayset name=3Dyourarray&dim=3D[t_numcarts],2,2][/arrayset] >=20 > # Populate your Array however you like (I'm just populating values for = the example): > [text]t_Cart=3D[lookup = db=3Dkeyed.db&value=3D[cartReference]&lookinfield=3D[kCart]&returnfield=3D= kCartID][/text] > [arrayset = name=3Dyourarray]([t_Cart],1,2)=3DTo&([t_Cart],2,1)=3DDonovan[/arrayset] >=20 > # To display: (remember, [t_Cart] =3D '1') > [yourarray([t_Cart],1,2)] (parses to 'To") > [yourarray([t_Cart],2,1)] (parses to 'Donovan') >=20 >=20 >=20 > Anyway, the only possible benefit of doing it this way, instead of = just using a table or database is that once > the data set is loaded into your array, actual references to it would = be fast. Otherwise, just use a table or=20 > .db I guess. >=20 > (this is all assuming I'm understanding your question) ;-) > Donovan >=20 > =20 > =20 > On Wednesday 19/12/2012 at 9:57 am, Palle Bo Nielsen wrote: >> Well, you are right I would like to create a lot of cells but not all = of them to be utilized. >>=20 >> Let me try to explain. I want to be able to use any cell from 0 to = a-very-big-number, but not all cells will be utilized; only very = specific numbers (cells) based on cart values which in the other = dimensions related to specific content in those cells. >>=20 >> Dim CART, A VALUE, A STRING >>=20 >> 10000001235301Hello >> 10000001045301To >> 10000001045310Donovan >>=20 >> In this case I can find a CART and very easily display any of the = other cells. >>=20 >> So baseline is that I do not need ALL billions of cell's, only = selected. >>=20 >> Does it make sense? >>=20 >> /Palle >>=20 >>=20 >> On 19/12/2012, at 01.38, Donovan Brooke wrote: >>=20 >>> Donovan Brooke wrote: >>>> You are trying to create an array with (likely over) 1 billion = dimensions? >>>=20 >>>=20 >>> What I meant to say Palle is that it appears you are trying to = create an array with at least or over 1B cells. I've never created an = array that large, and I would guess you are running into RAM issues = perhaps?? >>>=20 >>> Maybe post your code? >>>=20 >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> --=20 >>> Donovan Brooke >>> WebDNA Software Corporation >>> http://www.webdna.us >>> **[Square Bracket Utopia]** >>> --------------------------------------------------------- >>> 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 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- 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 --Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi = Donovan,

You are right on all your assumptions and = the reason to use Array is basically for me to get familiar with the = functionality within WebDNA but also because - and as you wrote "...once = the data set i loaded into your array, actual references to it would be = fast..." and this is spot on inside my Forum = project.

Anyhow; your Table-to-Array = alternative might be the right solution. Using a DB or a Table might be = second priority.

... and thank you very much = for your (and speedy) = feedback.

/Palle



On 19/12/2012, at 19.02, Donovan Brooke <dbrooke@webdna.us> = wrote:

If = you have a multi-dimensional array, where one of the dimensions has a = "[DimSize_]" of
over a billion, I would think that is going to be = unwieldy and probably not the solution you are really looking = for.

If you post the code that you are trying to use, I may be = able to better understand what you are trying to do...

However, = I'm guessing that you are only creating that large of an array because = you need one of the dimensions to
to match a cart number... (which = leaves a *lot* of wasted cells). 

(in that case, I'd = probably create a database or table for a keyed reference to the cart).. = ie:

keyed.db
------------------------------------------
kCart= <tab>kCartID
100000012353<tab>1
100000010453<tab>2=
------------------------------------------

# Find num = records
[text]t_numcarts=3D[search = db=3Dkeyed.db&nekCartdatarq=3Dfind_all][numfound][/search][/text]
<= br># Then you could create a much smaller array:
[arrayset = name=3Dyourarray&dim=3D[t_numcarts],2,2][/arrayset]

# = Populate your Array however you like (I'm just populating values for the = example):
[text]t_Cart=3D[lookup = db=3Dkeyed.db&value=3D[cartReference]&lookinfield=3D[kCart]&re= turnfield=3DkCartID][/text]
[arrayset = name=3Dyourarray]([t_Cart],1,2)=3DTo&([t_Cart],2,1)=3DDonovan[/arrayse= t]

# To display: (remember, [t_Cart] =3D = '1')
[yourarray([t_Cart],1,2)]  (parses to = 'To")
[yourarray([t_Cart],2,1)]  (parses to = 'Donovan')



Anyway, the only possible benefit of doing it = this way, instead of just using a table or database is that once
the = data set is loaded into your array, actual references to it would be = fast. Otherwise, just use a table or 
.db I = guess.

(this is all assuming I'm understanding your question) = ;-)
Donovan

 
 
On Wednesday 19/12/2012 at 9:57 am, = Palle Bo Nielsen wrote:
Well, you are right I would like to create a lot of = cells but not all of them to be utilized.

Let me try to explain. = I want to be able to use any cell from 0 to a-very-big-number, but not = all cells will be utilized; only very specific numbers (cells) based on = cart values which in the other dimensions related to specific content in = those cells.

Dim CART, A VALUE, A STRING

100000012353= 01Hello
10000001045301= To
10000001045310Donovan

In this case I = can find a CART and very easily display any of the other = cells.

So baseline is that I do not need ALL billions of cell's, = only selected.

Does it make sense?

/Palle


On = 19/12/2012, at 01.38, Donovan Brooke <dbrooke@webdna.us> = wrote:

Donovan = Brooke wrote:
You are = trying to create an array with (likely over) 1 billion = dimensions?


What I meant to say Palle is that it = appears you are trying to create an array with at least or over 1B = cells. I've never created an array that large, and I would guess you are = running into RAM issues perhaps??

Maybe post your = code?


Donovan





-- 
Donovan = Brooke
WebDNA Software Corporation
http://www.webdna.us
**[Square = Bracket = Utopia]**
---------------------------------------------------------
= This message is sent to you because you are subscribed to
the mailing = list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us
---------------------------------------------------------
This = message is sent to you because you are subscribed to
the mailing list = <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/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: archive= s: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_3B58BC9C-B420-45C0-BF9B-7948B82C100F-- Palle Bo Nielsen

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:

Emailer errors (1997) Nav. 4 probs with cart (1997) [HIDEIF] inside [FOUNDITEM] (1997) OT: test (1998) [Webcat 2]Next (1997) Re:FYI: Error message (1996) [showif] not working (2003) Cookie Crumble (1998) [WebDNA] anyone successfully using webdna with paypal's NVP API? (2008) MacWEEK article help needed (1996) [WebDNA] LinkedIn Network (2008) Re:Emailer (1998) Email within tmpl ? (1997) A sendmail warning (2005) Rhapsody? (1997) New Site Announcement (1998) UK credit card info follow-up (1997) Chat (2000) Re:trouble (1997) Just Testing (1997)