| Andres Olarte 2005-12-06, 8:26 pm |
| Couldn't you use a single ugly "SELECT *" with a cursor and then fill your
local cache as the client is scrolling through the table? It will scroll
kind of slow the first time, but then i'll work nice. I'm not very into
Swing, but for that you'd only need the number of rows with something like
"SELECT count(*)".
On 12/6/05, Kris Jurka <books@ejurka.com> wrote:
>
>
>
> On Tue, 6 Dec 2005, Joost Kraaijeveld wrote:
>
>
> There's got to be a better way of storing this index. If this is readonly
> data then you could easily number all of these in the database itself. I
> think the problem may be that you are trying to index all this data as an
> array where you need an absolute offset. Perhaps a different data
> structure would make a better backing type?
>
>
> How do you determine the records before and after at the moment?
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
|