in reply to RFC : AJAX + DBI = DBIx::LiveGrid

jZed, this is cool! I have one question:
 When I scroll down and back up, the grid hits the server for the data. Why can't the data/view be cached ?

Replies are listed 'Best First'.
Re^2: RFC : AJAX + DBI = DBIx::LiveGrid
by jZed (Prior) on Sep 15, 2005 at 03:12 UTC
    AFAIK, it has a buffer of pageSize (70 rows in the example) and it should only hit the server when it can't find what it needs in that buffer. How are you determining that its hitting the server with each scoll?
      I scrolled all the way down. Waited for the grid to fetch the values and scrolled back to the top.
        Yes, if you go from the bottom of the grid to the top of the grid and the table has more than pageSize rows, it will need to refresh. The buffer is sort of like a virtual view zone around the current scroll position and works best if you scroll a few rows at a time. Does that make sense and fit the behaviour you're observing?