Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Edit: final answer for real ultimate power!</p> <p>So for gridbox, you are basically taking i and j and interleaving their digits in base(square). E.g., given i and j in base(scale), you are computing:</p> <p>i(2)j(2)i(1)j(1)</p> <p>Where (n) signifies the digit base(scale).</p> <p>So that's easy enough to speed up: just keep a running tally of each digit's contribution to the final value of gridbox(...).</p> <p>Speeding up gridbox1(...) is even easier. Basically, you are computing:</p> <pre><code>Square * Square *(j\Square * Square + (j Mod Square)) </code></pre> <p>Now, <code>(j Mod Square)</code> expands to <code>(j - j\Square*Square)</code> which reduces the above to:</p> <pre><code>Square * Square *(j\Square * Square + (j - j\Square*Square)) </code></pre> <p>Which simplifies to:</p> <pre><code>Square * Square *(j\Square * Square + j - j\Square*Square) </code></pre> <p>Which simplifies to:</p> <pre><code>Square * Square * (j) </code></pre> <p>Here's the final loop:</p> <pre><code>Dim Square2 = Square * Square Dim Square3 = Square2 * Square Dim Square4 = Square2 * Square2 Dim j2_offset = 0 Dim j2_interleaved_offset = 0 Dim j2_value_offset= 0 For j2 = 0 To Square - 1 Dim j1_offset = 0 Dim j1_interleaved_offset = 0 For j1 = 0 To Square - 1 Dim i2_offset = 0 Dim i1_interleaved_offset = 0 For i2 = 0 To Square - 1 For i1 = 0 To Square - 1 Dim box = j2_offset + j1_offset + i2_offset + i1 gridbox(box) = j2_interleaved_offset + i2_interleaved_offset + j1_interleaved_offset + i1 gridbox1(gridbox(box)) = j2_offset + j1_offset Next i2_offset += Square i2_interleaved_offset += Square2 Next j1_offset += Square2 j1_interleaved_offset += Square Next j2_offset += Square3 j2_interleaved_offset += Square3 Next </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to simplify this Sodoku Code?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMSN
    1. USMSN
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to simplify this Sodoku Code?
      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. COdon't worry about the syntax, when it's done I will try it and fix it if needed and I will tell you if it work, like I did with the other one
      singulars
      1. PO
      1. USFredou
    2. COquestion, is i2_interleaved_offset a typo of j2_interleaved_offset ?
      singulars
      1. PO
      1. USFredou
    3. CONope. Basically, it's there to take i2i1 and j2j1 and merge them to form j2 i2 j1 i1.
      singulars
      1. PO
      1. USMSN
 

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