What if the table has 10^16 or more items?
Is that number within the limits as set by SQLite3 ? Than its my intention
to handle it.
No, I just made that up out of thin air. SQLite's maximum row limit is 2^63-1 I
believe. It is unreachable on current physical media.
Oh, there are some the
- wrote:
>> Are you using a list view, or paging? The scrolling
>> cursor method is appropriate only for the latter.
>
> I'm using a report-style listview. And to be honest, I have no idea what a
> "paging" component looks like (I'm using standard windows components).
This would be a list withou
Hello Ryan,
> What if the table has 10^16 or more items?
Is that number within the limits as set by SQLite3 ? Than its my intention
to handle it.
*How* I would handle it is a whole other matter. The "scrolling cursor"
method would be good for that, as it does only works with (very) small part
I've done it a long time ago before discovering that limit/offset was not
the way to go
http://www.codeproject.com/Articles/26938/AlphaView
Anyway, it worked quite well even on slow pda.
Best wishes
Noel
On 10 July 2014 15:19, - wrote:
> Hello Clemens,
>
> > Are you using a list view, or pagi
Hello Clemens,
> Are you using a list view, or paging? The scrolling
> cursor method is appropriate only for the latter.
I'm using a report-style listview. And to be honest, I have no idea what a
"paging" component looks like (I'm using standard windows components).
> The easiest way to handle
OP is in windows. Windows can send you display cache hints that tells
you what page it intends to display next. I use these notification to
load up a page worth of data at a time. Keep it in an internal cache.
>> the ammount of memory needed to store all the rowIDs in could well exeede
>> the ammo
On 10 Jul 2014, at 12:54pm, - wrote:
> But it might cause another problem: the database could get/be so large that
> the ammount of memory needed to store all the rowIDs in could well exeede
> the ammount of memory available to the program.
> I could ofcourse use (or at that moment switch over
Hello Simon,
> You've just listed a lot of the concerns involved in the use of
> scroll-page-by-page. And there are no good answers to them.
Thanks for the above. It means that I did my homework right. :-)
> Nor is it possible to tell SQLite to ... Sorry about that.
I already got that feeli
- wrote:
> After having used the OFFSET and LIMIT 1 method (in conjuction with a
> userdata listview) and finding a past post into this forum describing it as
> a rookie mistake I'm now trying to implement the "scrolling cursor" method
> in that same post.
Are you using a list view, or paging? Th
On 9 Jul 2014, at 2:03pm, - wrote:
> 1) Is it possible to refer to the columns in a kind of shorthand (index
> perhaps) ?
>
> 2) Is it possible to have the SQLite engine initialize and remember certain
> WHERE and ORDER clauses (without creating another database please :-) ), so
> they can be u
How about using prepared statements in conjunction with bind?
http://www.sqlite.org/c3ref/bind_blob.html
Kind regards,
Philip Bennefall
On 2014-07-09 15:03, - wrote:
Hello all,
I'm quite new at SQLite3, and have a bit of a problem with grasping the
handling of a database.
After having used
Hello all,
I'm quite new at SQLite3, and have a bit of a problem with grasping the
handling of a database.
After having used the OFFSET and LIMIT 1 method (in conjuction with a
userdata listview) and finding a past post into this forum describing it as
a rookie mistake I'm now trying to implemen
12 matches
Mail list logo
