Help on understand "how" I can obtain performance on large data

7 posts, 0 answers
  1. Vincenzo Angiolino
    Vincenzo Angiolino avatar
    2 posts
    Member since:
    Nov 2009

    Posted 15 Apr 2010 Link to this post

    Hi,
    I am new on Telerik and especially on OpenAccess;
    I am starting on port applications and I need to understand how I can obtain the best result on data fetching;
    I am talking on WPF (Silverlight in the second time) and OpenAccess;
    If want simply query a large data table of 1 million of record and 100 columns (I start with tests, like everybody);
    You tell us about performances, data virtualization, and asyncronous load in grids......but, if I use a Radgrid with all performances options on, and I launch a simple Linq select on that table, the resut is the server hang-up because OpenAccess generate a select for all records.
    How I can query (without my intervent and without filter the table in the application) and fetch "incrementally" data without crash the data server ?
    I have tried Devexpress components (I am a fan of Devexpress and Telerik components) and their approach is perfect: the grid generate (via Server-mode) sql for fetch only few necessary records for fill UI, even if I have request all records, so the server resources are preserved because it is queried "on demand" when I scroll the grid.
    How I can obtain a similar result with RadGrid (Wpf) and OpenAccess?
    Thanks in advance,
    (sorry for my english).

    Stefano Monterisi
    Sestante Bulgaria




  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 20 Apr 2010 Link to this post

    Hello Vincenzo Angiolino,

    You could bind the RadGridView.ItemSource property to a QueryableCollectionView of items. The QueryableCollectionView represents a view for grouping, sorting, filtering and paging data collection using Linq base query operators:

    this.RadGridView1.ItemsSource = new QueryableCollectionView(context.Customers);

    You could find useful the provided from us sample application.

    Sincerely yours,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. DevCraft banner
  4. Zbigniew Kozłowski
    Zbigniew Kozłowski avatar
    60 posts
    Member since:
    Apr 2010

    Posted 21 Apr 2010 Link to this post

    Hi,
    is it possible to do it somehow over WCF ?

    Regards,
    Zbigniew Kozłowski
  5. TSE
    TSE avatar
    381 posts
    Member since:
    Sep 2008

    Posted 21 Apr 2010 Link to this post

    Hi there,

    Regarding WCF - have you had a look at the Data Services Wizard?
    I think it is doable using it - otherwise one could always implement some DTO's (as DataContract classes for the WCF endpoints) over the persistence model and send those across the wire.

    Regards
    Henrik
  6. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 22 Apr 2010 Link to this post

    Hi Zbigniew,

    You can follow the Henrik's idea. The Data Services Wizard is available here.
    If any questions arise please contact us back.

    Greetings,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  7. Vincenzo Angiolino
    Vincenzo Angiolino avatar
    2 posts
    Member since:
    Nov 2009

    Posted 24 Apr 2010 Link to this post

    Hi Damyan,
    thank you for the help.
    Now what I need for migrate from desktop app to Silverlight is a grid that can 'paging' transparently to user; so the paging must be managed by the vertical scrollbar and the virtualization must be the rest.
    The user, then, can scroll millions of records as they are already on the client. This is the devexpress server-mode approach and it is very powerful.
    My customers avoid paging on intensive applications...:-)
    Another need (and I think those are basic request for professional LOB in the real world) is a direct incremental search on grid columns, and an incremental filter. 
    Now this a leak features in your grid, but I cannot start projects with those features; Otherwise I have to change my application concept.

    Thanks,

    Stefano Monterisi
    Sestante   
  8. Milan
    Admin
    Milan avatar
    1989 posts

    Posted 29 Apr 2010 Link to this post

    Hi Vincenzo Angiolino,

    Our data engine can fully utilized the power of SQL servers and combined with our powerful virtualization mechanism you can works with millions of records at a time. This sample demonstrates how our virtualization mechanism can handle 50 million cells. We currently do not have a built-in mechanism of adjusting the page-size using the vertical scrollbar but one of my colleagues has blogged about implementing this functionality with just a few lines of code.

    The incremental search and filter features are not provided out of the box but they can be implemented without too much effort. We have a "Search as you type" example which demonstrates this type of filtering. We currently do not have an example of incremental search but we could prepare such sample for you we just need some more information about the behavior that is expected.

    Hope this information is helpful.

    Regards,
    Milan
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top
DevCraft banner