« previous next »
Pages: [1]

Author Topic: Dealing with data on a page  (Read 16196 times)

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Dealing with data on a page
« on: November 09, 2010, 04:23:10 PM »
http://www.flexigrid.info/

Just come across this, and will be implementing in the back end of our site.


What the developer says:
Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, plus an ability to connect to an xml based data source using Ajax to load the content.

Similar in concept with the Ext Grid only its pure jQuery love, which makes it light weight and follows the jQuery mantra of running with the least amount of configuration.

Features

    * Resizable columns
    * Resizable height and width
    * Sortable column headers
    * Cool theme
    * Can convert an ordinary table
    * Ability to connect to an ajax data source (XML and JSON[new])
    * Paging
    * Show/hide columns
    * Toolbar (new)
    * Search (new)
    * Accessible API
    * Many more

I'm planning to add an Editable and Resortable rows feature, as well as other cool GUI features.

One of my main goal for the plugin is ultimately to keep it lightweight, maybe under 20k when compressed. Because otherwise you should probably stick with Ext Grid or YUI data table.
Logged
... Make sure you live before you die.

rcjordan

  • I'm consulting the authorities on the subject
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 16421
  • Debbie says...
    • View Profile
Re: Dealing with data on a page
« Reply #1 on: November 09, 2010, 05:45:12 PM »
Rupert, G is indexing ajax pages now if you follow their quasi-beta protocol. 

Try site:bookwhack.com +"!#"

G's spec here: http://code.google.com/web/ajaxcrawling/docs/specification.html
Logged

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Re: Dealing with data on a page
« Reply #2 on: November 10, 2010, 09:40:12 AM »
thx Guys.   I will be using it in the back end part the customers never see, but that is relevant to me elsewhere RC.

Google surfing Ajax now eh?   Well I only build my site with a million pages so that I could point my customers at an exact page with their sizes selected... nothing to do with google of course :) 
 
Logged
... Make sure you live before you die.

rcjordan

  • I'm consulting the authorities on the subject
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 16421
  • Debbie says...
    • View Profile
Re: Dealing with data on a page
« Reply #3 on: November 10, 2010, 12:21:23 PM »
>only build my site with a million pages

Sounds like it's worthwhile to try the ajax setup. I can't see any harm.
Logged

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Re: Dealing with data on a page
« Reply #4 on: November 10, 2010, 12:25:05 PM »
Yes, we Ajax for the user too :)
Logged
... Make sure you live before you die.

Gurtie

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1628
    • View Profile
Re: Dealing with data on a page
« Reply #5 on: November 10, 2010, 01:59:16 PM »
is anyone actualy using Googles workaround? I know its been around for a year or so now (unless this is a new one?) and I thought at the time it looked like a really bad solution to the problem - although I can't code more than the basics so perhaps I'm missing something? Would you not just be better making static url's if you really really need indexable ajax?

My other problem was it doesn't solve the problems for Yahoo and Bing anyway. Yeah I know, who cares, but I'd rather at least get sites indexed everywhere if possible.
Logged

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Re: Dealing with data on a page
« Reply #6 on: November 11, 2010, 04:40:36 PM »
RC,   Tried to sticky you, did you get it?
Logged
... Make sure you live before you die.

grnidone

  • Inner Core
  • Hero Member
  • *
  • Posts: 1652
    • Yahoo Instant Messenger - e
    • View Profile
    • Email
Re: Dealing with data on a page
« Reply #7 on: November 11, 2010, 05:29:35 PM »
OK, maybe I'm stupid.  But it just looks like a database.  With a hook that allows an easy way to dump an xml feed into it.

Am I wrong?
Logged

jatar_k

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Dealing with data on a page
« Reply #8 on: November 18, 2010, 03:11:04 AM »
the issues I have had with some of the grids is some load the full dataset everytime and when you page through they load it again, and again

aside from that they're kinda purty when they don't load 30k records to show 10
Logged

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Re: Dealing with data on a page
« Reply #9 on: November 18, 2010, 11:08:35 AM »
Heather, no, I thinks that's right.

jatar_k is there a way round that?
We are trying to reduce the calls to the database, so the start is (as I understand it) to put the base data required into a separate table, so we dont have to call 30,000 lines every time.

We have a table with 10 items in it, and if something in the 30,000 changes, then that table of 10 is edited.

I guess we know we only want "live" data, not all of it in our case.   Not being a data expert, I really have no idea what I am talking about, just what I understand of how it has been explained to me :)
Logged
... Make sure you live before you die.

jatar_k

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Dealing with data on a page
« Reply #10 on: November 19, 2010, 12:13:52 PM »
for this style of paging where you don't hit the db for every 10 items and reload the whole page you need some type of caching but really it depends on how slow the queries are, if db traffic is an issue it may be you need more server or it may be innefficient queries, hard to say

tsome solutions load the whole shootin match and then page them which works for middling sizes, what that means depends on too many things

essentially if you feel it's slow then you need to change something, jquery is less about efficiency (my opinion after viewing a bunch of implementations) than it is about pretty. The cool thing with only changing a div is the user still has stuff to look at, not a blank screen waiting for a page to load, so long as the user feels like they are in control (less than 1 sec loads) then you're fine
Logged

Rupert

  • Inner Core
  • Hero Member
  • *
  • Posts: 3359
  • George in a previous life.
    • View Profile
    • SuitsMen
Re: Dealing with data on a page
« Reply #11 on: November 19, 2010, 12:54:21 PM »
At the mo, we are, as I understand it, pulling too much on the DB. A part of the implementation is to speed things up, a part to make it look pretty....  that's Richard, the programmer :)

Quote
...need more server ...
ah if only I knew when the server is overloaded :)  But that is another day.

Thanks for you feedback jatar_k...  appreciated.
Logged
... Make sure you live before you die.

Cowley

  • Inner Core
  • Newbie
  • *
  • Posts: 35
    • View Profile
Re: Dealing with data on a page
« Reply #12 on: November 22, 2010, 10:36:56 PM »
Thanks for that, looks good. Have passed it to the coders.
Logged
Pages: [1]
« previous next »