Re: [sqlite] Limit COUNT

What about this: SELECT CASE count(*) WHEN 5000 THEN 'More than 5000' ELSE 'Less than 5000' END FROM (SELECT ID FROM table ORDER BY whatever LIMIT 5000 OFFSET 25000) Fabian schrieb: > 2011/10/16 Frank Missel > >> What do you want to attain with the count? >> >> > I want to

Re: [sqlite] LevelDB benchmark

they used CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) CREATE INDEX keyindex ON test (key) on random replaces it doubles the write operations. J Decker schrieb: > On Wed, Jul 27, 2011 at 6:22 PM, Stephan Wehner > wrote: >> There are some benchmark's

Re: [sqlite] SELECT query first run is VERY slow

Think about the distribution of your Data. select count(*) as cnt,kind,computer from log group by kind,computer order by cnt desc what happens here? SELECT * FROM log INDEXED BY idxlog_kind_computer WHERE kind = 'info' AND computer=1 and id > 7070636 LIMIT 100; there are 3_022_148 identical

Re: [sqlite] [mlist] How to search column ascii containing chr(0)

iip schrieb: > Hi All, > > As subject, I want to know how search column that contain ascii chr(0), I > already use google to search but no luck, > > I'm using python language. > > Thanks in advance, > > -iip- > ___ > sqlite-users mailing list >

Re: [sqlite] [mlist] Re: round documentation

Matt Young schrieb: > I second that documentation confusion. There is no truncate to > integer, though I wish it would. > Try this, SELECT CAST(4.5 AS INTEGER), CAST(ROUND(4.5, 0) AS INTEGER) ___ sqlite-users mailing list sqlite-users@sqlite.org