Re: [sqlite] COUNT() on indexed tables / primary key with 100'000records

Hello Lets say i have 120'000 records and worst case is that upto 90'000 records match the conditions. Daniel Ursprüngliche Nachricht Von: [EMAIL PROTECTED] Datum: 13.07.2008 17:16 An: Betreff: Re: [sqlite] COUNT() on indexed tables / primary key with 100'000r

Re: [sqlite] COUNT() on indexed tables / primary key with 100'000records

<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have following table with around 100'000 rows / ~10MB on a embedded > device: > > CREATE TABLE 'fs_main' ( > 'fs_recid' INTEGER PRIMARY KEY NOT NULL, > 'fs_contenttype' INTEGER, > 'fs_itemtype' INTEGER, > 'fs_job' INTEGER, > 'fs_textid