Hello, Richard!
Probably PTR_SZ or PAGE_PTR_SZ would be good?
I feel confusing about OVFL_. Why size of the pointer to the first overflow
page could be different from size of another pointers?
Sorry, I'm far from the code and should not discourse. Just have an idea
that name should be as common
Hi Keith,
2015-01-09 2:02 GMT+03:00 Keith Medcalf :
>
> The table you are creating is called a keyset snapshot. That is how all
> relational databases databases which support scrollable cursors implement
> them (only navigable databases -- hierarchical or network or network
Hi Clemens,
2015-01-08 13:34 GMT+03:00 Clemens Ladisch :
> >
> http://stackoverflow.com/questions/21082956/sqlite-scrolling-cursor-how-to-scroll-correctly-with-duplicate-names
> > and yes, we can use title+rowid as lasttitle. But... it looks too complex
> > to be 'best
. And firebird feels slow. So SQLite wins!
Thanks,
Max
2015-01-08 3:23 GMT+03:00 Richard Hipp <d...@sqlite.org>:
> On 1/7/15, Max Vasilyev <maxrea...@gmail.com> wrote:
> > Hi guys,
> > Is it possible to get key number from the index?
> > For example let's conside
Hi guys,
Is it possible to get key number from the index?
For example let's consider Figure 4: An Index On The Fruit Column from here
https://www.sqlite.org/queryplanner.html
index_rownum, fruit, rowid
1 Apple 2
2 Grape 5
3 Lemon 18
4 Orange 1
5 Orange 23
...
Is it possible to add rownum column
Hi gents,
I just want to show DataGrid with my table to a user with support of
sorting and filtering by arbitrary column.
As my table has ~200k records I'd like to implement data virtualization
(paged access).
Please, give me recommendations how to do pagination in the best way.
The following is
6 matches
Mail list logo