Results 1 to 7 of 7

Thread: jQuery and SlickGrid - 90,000 rows!

  1. #1

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    jQuery and SlickGrid - 90,000 rows!

    I just wanted to post that I have just had great success using jQuery/AJAX to call back a JSON array that has 90,000 objects representing rows in a table.

    Total size of the RESPONSE:

    Content-Length 25453477

    It took 35 seconds for the data to fully arrive in my browser (from a server 2 states away - so not in my office).

    I'm using a SlickGrid to display the 90,000 rows. It's got a virtual viewport and scrolls effortlessly through the data.

    I've got a JavaScript class that manages this JSON array - I can filter on fields, multi column sort, etc - all that JavaScript code runs as fast as if the grid has 90 rows!

    I've never seen a MSFlexGrid work as well as this - or whatever they call the grid in .Net these days.

    I love JavaScript - who would ever think that a freeware product like a FireFox browser could be robust enough to handle complex WinForm-like UX tasks!

    imo - even better then a winform app.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  2. #2
    Super Moderator dday9's Avatar
    Join Date
    Mar 2011
    Location
    South Louisiana
    Posts
    11,698

    Re: jQuery and SlickGrid - 90,000 rows!

    I've never heard of a SlickGrid control before. A quick Google search returns a GitHub example, is this the same one that you're referring to?
    "Code is like humor. When you have to explain it, it is bad." - Cory House
    VbLessons | Code Tags | Sword of Fury - Jameram

  3. #3

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: jQuery and SlickGrid - 90,000 rows!

    Yes that is the control. I've used it for 3 years now.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4
    Super Moderator dday9's Avatar
    Join Date
    Mar 2011
    Location
    South Louisiana
    Posts
    11,698

    Re: jQuery and SlickGrid - 90,000 rows!

    Ok, I'll have to check that out.

    This is an exciting time for web developers, because we're seeing the rise of controls that are not only much more pleasant to look at but also out perform many windows form controls. Stuff like this gives me the frissons!
    "Code is like humor. When you have to explain it, it is bad." - Cory House
    VbLessons | Code Tags | Sword of Fury - Jameram

  5. #5

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: jQuery and SlickGrid - 90,000 rows!

    Search the forum here for slick grid and you will find posts and threads by me over the past couple of years - some with screen shots.

    I drive the "column definitions" for my grids from a table in the database so I can make grid changes in the web app with simple updates to a table or two.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  6. #6
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    6,594

    Re: jQuery and SlickGrid - 90,000 rows!

    Quote Originally Posted by szlamany View Post

    I've never seen a MSFlexGrid work as well as this - or whatever they call the grid in .Net these days.
    It's called MS-BullGrid.

    We have recently bought the full Telerik web package at work. I haven't had a change to work with that but I hope it is better than the devexpress BS (BS web controls, forms are OK).
    I suggested the slickgrider but then I got sick and I had a leave of absence and I was not around to convince them with an example. So the second suggestion was the Telerik (I was totally against Devexpress as I have worked(forced) with it in the past on a software house and I was furious of the bugs (luckily I found another job back then and left this behind)).
    We only have a need to support some of our Head Office users (5-10 people in 2 departments) so it's not so bad to just have this server side, as all it takes is to pass an SQL VIEW and they can filter the data fine.
    So for this implementation and a quick fix, it's fine.
    For a full scale app I would have to convince them on slickgrid. Then again, we are not a software house here, so I don't think we are going to have full scale web apps created in house.
    But the need would be for about 30.000 - 100.000 hits per days, so I don't think server side could handle this well (at least not anything Microsoft has made. PHP, if I was well trained at, maybe).
    So I guess if I have time I will continue on PHP and Javascript as MVC is total bull and I can adopt web services with PHP.
    ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
    πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·

  7. #7
    Frenzied Member tr333's Avatar
    Join Date
    Nov 2004
    Location
    /dev/st0
    Posts
    1,605

    Re: jQuery and SlickGrid - 90,000 rows!

    I've had similar success using DataTables.
    CSS layout comes in to the 21st century with flexbox!
    Just another Perl hacker,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width