Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here is my two cents:</p> <p>I'd go with keeping a clean copy of your original array for fastest performance. You can either keep a referenced hard-coded copy</p> <pre><code>var vectorsOrig = [ [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0] ]; </code></pre> <p>or do a dynamic clean clone of the initial array using slice ((recursively in your case for deep copy):</p> <pre><code>var clonedVectors = [0, 0, 0, 0, 0].slice(0); </code></pre> <p>Regardless, taking the approach of <strong>resetting your vector reference to an original copy will be faster than cycling through and resetting each node</strong>. If your old vector array object isn't referenced any more, JavaScript will garbage collect it. </p> <p>With that said, the question becomes of obtaining a clean copy each and every time. Having once hard-coded instance will give you one clean copy and you'll have to clone it thereafter. Nor do you want to into dynamic generation via similar for loops as the reset option. My advice is to write a clone function that simply returns a new hard-coded or initialized array:</p> <pre><code>function newVector() { return [ [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0], [0, 0, 0, 0, 0] ]; } var vector = newVector(); vector[1][2] = 11; console.dir(vector); vector = newVector(); // your old array will be garbage-collected if no longer referenced by any other reference console.dir(vector); </code></pre> <p>Ideally, it's best to benchmark various approach. </p> <p><strong>EDIT</strong> Thanks to Vega's input, I've modified his test to test three approaches. In Chrome and IE9, this solution seems to be the fastest, in FF (15.0.1) manual iteration seems faster (memory allocation/management slower in FF possibly). <a href="http://jsperf.com/array-zero-test/2" rel="nofollow">http://jsperf.com/array-zero-test/2</a></p>
    singulars
    1. This table or related slice is empty.
    1. POFastest way to reset a multidimensional array?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UScbayram
    1. UScbayram
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFastest way to reset a multidimensional array?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COUnfortunately, slice seems to be slower than updating the nodes http://jsperf.com/array-zero-test
      singulars
      1. PO
      1. USSelvakumar Arumugam
    2. COThis looks like Mohammad Goudarzi's solution, though you explain your rationale a bit better.
      singulars
      1. PO
      1. USbeta0x64
    3. CODepends on the environment (browser). For Chrome 22.0.1229.96 32-bit on Windows Server 2008 R2 / 7 64-bit, it's faster.
      singulars
      1. PO
      1. UScbayram
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload