Re: 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 ?

Comment on Re: RFC : AJAX + DBI = DBIx::LiveGrid

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?	[reply]
Re^3: RFC : AJAX + DBI = DBIx::LiveGrid by InfiniteLoop (Hermit) on Sep 15, 2005 at 14:33 UTC
I scrolled all the way down. Waited for the grid to fetch the values and scrolled back to the top.	[reply]
Re^4: RFC : AJAX + DBI = DBIx::LiveGrid by jZed (Prior) on Sep 15, 2005 at 14:45 UTC
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?	[reply]