-----Original Message----- From: Paul Bohme [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 2:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ring buffer table
Cory Nelson wrote: >afaik, sqlite doesn't store row counts so count(*) causes a full table scan. > >On 12/23/05, Axel Mammes (gmail) <[EMAIL PROTECTED]> wrote: > > >>Wouldn´t a SELECT COUNT(*) just read the table header and get the >>amount of records from there? That should be faster and simpler than >>maintaning a separate table for the counters. >> >> --Is a good question, I might have to crack into it and have a look (to know for sure what it --does..) Depending on the database a single counter is a perfect spot for locking contention so --many don't have a count of rows or other entities, thus I didn't really expect SQLite to have it. Since sqlite doesn't implement row-level or table-level locking, wouldn't the issue of locking contention hotspots be mute? An admitted db newbie, Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors. >
