Databases
StackOverflow2013
Postsdbo
POHow to get this really fast?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get this really fast?
    primarykey
    data
    text
    <p>I have a framework that allows users to do queries to a specific datasource (the Football Manager 2010 ingame database, for those of you interested).</p> <p>In this framework, I have two different modes wherein my framework can run: realtime and cached mode. I want users who use this framework to be able to switch by just calling a different constructor (e.g. <code>new Context(Mode.Cached)</code>). That should be the only switch a user should make, so he can still have all the same Linq calls, but just use Cached mode when his application fits better. Clear.</p> <p>I had decided that using PostSharp should be my best choice because:</p> <ul> <li>Create an aspect on every property (that's already been decorated by an attribute)</li> <li>In that aspect, check whether we are in <code>Cached</code> or <code>Realtime</code> mode</li> <li>Return the value either from memory or from cache</li> </ul> <p>Well that works. BUT! Speed is not good enough. When doing the following on 90.000 objects:</p> <pre><code>foreach (Player p in fm.Players) { int ca = (short)ProcessManager.ReadFromBuffer(p.OriginalBytes, PlayerOffsets.Ca, typeof(Int16)); } </code></pre> <p>It takes only 63 ms. (ReadFromBuffer is a highly optimized function which takes <code>byte[], int, Type</code> and returns <code>object</code>), 63 ms is very reasonable considering the large amounts of objects.</p> <p><strong>But!</strong> In PostSharp, I implemented quite the same using this:</p> <pre><code> public override void OnInvocation(MethodInvocationEventArgs eventArgs) { if (eventArgs.Method.Name.StartsWith("~get_")) { if (Global.DatabaseMode == DatabaseModeEnum.Cached) { byte[] buffer = ((BaseObject)eventArgs.Instance).OriginalBytes; eventArgs.ReturnValue = ProcessManager.ReadFromBuffer(buffer, this.Offset, eventArgs.Method.ReturnType); } </code></pre> <p>Now I call this using</p> <pre><code>foreach (Player p in fm.Players) { int ca = p.CA; } </code></pre> <p>And it takes <em>782 ms</em>, more than 10 times as much!</p> <p>I created the aspect as:</p> <pre><code>[Serializable] [MulticastAttributeUsage(MulticastTargets.Method, PersistMetaData = true)] internal class FMEntityAttribute : OnMethodInvocationAspect { public FMEntityAttribute(int offset, int additionalStringOffset) { this.Offset = offset; this.AdditionalStringOffset = additionalStringOffset; } //blah blah AOP code } </code></pre> <p>And the property is decorated like</p> <pre><code> [FMEntityAttribute(PlayerOffsets.Ca)] public Int16 CA { get; set; } </code></pre> <p>How can I get this to perform well?!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJan Jongboom
    1. USJan Jongboom
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to get this really fast?
      1. USJB King
      1. VTFavorite
    2. VO
      singulars
      1. POHow to get this really fast?
      1. USJan Jongboom
      1. VTFavorite
    1. COWhat did your profiling run indicate was the expensive hot spot?
      singulars
      1. POHow to get this really fast?
      1. USEric Lippert
    2. COThat most time was spent in my property getter, not really useful info.
      singulars
      1. POHow to get this really fast?
      1. USJan Jongboom
 

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