Re[2]: [sqlite] Speed of a count operation

Hello Nathan, Thanks. Counting on the primary key made a HUGE difference in performance. I didn't really expect that but, am pleased with the results. I did the .explain and explain but, wasn't sure what it was telling me. C Thursday, December 8, 2005, 1:14:10 PM, you wrote: NK> On Thu, Dec

Re: [sqlite] Speed of a count operation

On Thu, Dec 08, 2005 at 12:26:44PM -0500, Teg wrote: > I have a 6.5 gb database with 29,587 records in it. It takes about > 30-40 seconds for a count to return the first time I specify one in > "Sqlite3" (seeing this in my program as well). Subsequent "count" > operations are nearly instantaneous e

[sqlite] Speed of a count operation

Using 3.2.7 I have a 6.5 gb database with 29,587 records in it. It takes about 30-40 seconds for a count to return the first time I specify one in "Sqlite3" (seeing this in my program as well). Subsequent "count" operations are nearly instantaneous even when I exit Sqlite3 and restart. I'm pretty