Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are several options</p> <ol> <li>Firstly, is the code correctly structured? For example, do you really need to re-process everything or can a re-write be more efficient?</li> <li>If you cannot avoid resource intensive code, notify the user with a progress bar or message. Also consider the use of DoEvents which frees up the operating system so that Excel can process other events.</li> <li>DoEvents is slow and dirty. Even better look at this link <a href="http://www.vbforums.com/showthread.php?t=315416" rel="nofollow noreferrer">DoEvents is slow!!! Here are faster methods</a></li> <li>Rewrite your code to work asynchronously. Create a class, a handler and deal with each transaction asynchronously.</li> <li>You could write some VBScript/Javascript and push the task out to run independently of Excel/VBA. Eg there's an example <a href="https://stackoverflow.com/questions/6238215/how-to-call-vbscript-from-excel-macros/6240335#6240335">Here</a></li> <li>Don't use VBA :)</li> </ol> <p><strong>Edit:</strong> How are you filtering? If you're iterating through thousands of items in an array testing for criteria it can be very slow. Excel's <code>Advanced Filter</code> is very quick and could process hundreds of thousands of rows with multiple criteria quickly.</p>
    singulars
    1. This table or related slice is empty.
    1. POVBA maintaining the program in memory
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USosknows
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTUpMod
    1. COThanks, osknows. My first reactions are to your suggestions 1 and 6. First a little background: the transactions are option trades. Reading them takes a fair bit of processing, because they come from different sources with eg different sign conventions and units. And because some features have to be computed. I read each trade into an Option-Deal object. I then compile the deals into several different (overlapping) portfolios--trading desk, trading book (under a desk), underlying type, etc. The user selects a particular portfolio from all the combinations. A portfolio is much smaller than...
      singulars
      1. PO
      1. USRomnieEE2
    2. COthe set of trades underlying it, in memory consumption. Oh and Option-Portfolio is another object. The first thing that occurs to me is that maybe I could output the portfolio data to a sheet, and just read that instead of re-reading all the trades. The difficulty with that is creating a lot of code to export and import as text. (Would this be "serializing" an object in C#? Which presumably VBA can't do?) Aside from exporting and importing text (and maybe serializing), I don't know what else suggestion 4 would mean for this problem--?
      singulars
      1. PO
      1. USRomnieEE2
    3. COOh and as far as the filtering and reading go--I iterate through rows of the trade log one at a time, reading text, and then doing various processing in the code. The "filtering" right now is done primarily just by picking a key from a Dictionary that contains all the portfolio objects (where the key matches the fields the user chooses in the combo boxes). I mean to developing more filtering at the level where the Trade objects are added to the Portfolio objects. This would entail, while For/Each looping through the Dictionary of Deal objects, applying conditionals to the deal properties...
      singulars
      1. PO
      1. USRomnieEE2
 

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