Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

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

by InfiniteLoop (Hermit)
on Sep 15, 2005 at 03:08 UTC ( #492112=note: print w/replies, xml ) Need Help??


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?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://492112]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2022-05-25 07:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (85 votes). Check out past polls.

    Notices?