Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>you will find lots of related question on Stack Overflow, however not all of them mention that one of the most high performance ways to draw large amounts of data to the screen is to use the <a href="http://msdn.microsoft.com/en-us/library/system.windows.media.imaging.writeablebitmap.aspx" rel="nofollow noreferrer">WriteableBitmap</a> API. I suggest taking a look at the <a href="https://github.com/teichgraf/WriteableBitmapEx/" rel="nofollow noreferrer">WriteableBitmapEx</a> open source project on codeplex. <em>Disclosure, I have contributed to this once, but it is not my library</em>. </p> <p>Having experimented with DrawingVisual, StreamGeometry, OnRender, Canvas, all these fall over once you have to draw 1,000+ or more "objects" to the screen. There are techniques that deal with virtualization of a canvas (there' a <a href="http://blogs.msdn.com/b/kaelr/archive/2010/08/11/zoomableapplication2-a-million-items.aspx" rel="nofollow noreferrer">million items demo</a> with Virtualized Canvas) but even this is limited to the ~1000 visible at one time before slow down. WriteableBitmap allows you to access a bitmap directly and draw on that (oldskool style) meaning you can draw tens of thousands of objects at speed. You are free to implement your own optimisations (multi-threading, level of detail) but do note you don't get much frills with that API. You literally are doing the work yourself. </p> <p>There is one caveat though. While WPF uses the CPU for tesselation / GPU for rendering, WriteableBitmap will use CPU for everything. Therefore the fill-rate (number of pixels rendered per frame) becomes the bottleneck depending on your CPU power. </p> <p>Failing that if you really need high performance rendering, I'd suggest taking a look at <a href="http://sharpdx.org/" rel="nofollow noreferrer">SharpDX</a> (Managed DirectX) and the interop with WPF. This will give you the highest performance as it will directly use the GPU. </p> <p>Best regards, </p>
    singulars
    1. This table or related slice is empty.
    1. POHigh performance graphics using the WPF Visual layer
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDzmitry Lahoda
    1. USDr. ABT
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHigh performance graphics using the WPF Visual layer
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, this is interesting. I would prefer to use the WPF graphics if possible though, as I have previously created GIS programs using GDI+ and I would prefer now to try something that is making use of the GPU. When you say "objects", do you mean Visual objects, or would say several lines in a single Visual count as several objects?
      singulars
      1. PO
      1. USGreg
    2. COHi Greg, when I said objects I meant rendered items, whether they be drawn by GDI, or WPF visuals etc... Regarding wpf's GPU acceleration, all that performance boost and more is lost by CPU side layout and tesselation. Please see my website here http://goo.gl/1nCpw for a demonstration of what a bitmap approach can do, and compare to other similar components here http://goo.gl/ohLFj achieve with the wpf rendering primitives.
      singulars
      1. PO
      1. USDr. ABT
 

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