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:

Undocumented date issues? (1998) WebCatalog 3.0 manual in binder (1998) Duplicate Cart Problem in Netscape SOLUTION (2000) Cart Creation (1998) WebCatalog (1998) Too many wrong answers! (1998) Emailed problem (2000) Numbers from Sentence (2003) [WebDNA] Authorize working connection... (2020) Frames and WebCat (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) one item in several different categories? (2000) Finding max value for a field (1997) MacWEEK article help needed (1996) TCPConnect to query for Domain expiration (2000) RE: E-mailer error codes (1997) blank page from template (1997) Some Questions (1997) Trouble with formula.db (1997) WebSTAR 2.1 freezes my Mac (1997)