[sqlite] Tomcat 6 consumes too much memorys

The same query and database are fine if running from the command line sqlite3 or from java command line (via jdbc). Any one has the same issue please? Thanks a lot in advance -- James Qian Wang Mobile: 44 7986 099 233

[sqlite] Query tooooo sloooooooooow

I agree. Thank you all. On Thu, Jul 30, 2015 at 3:44 PM, Clemens Ladisch wrote: > James Qian Wang wrote: > > 0|0|0|SCAN TABLE contact AS c USING COVERING INDEX elid2 > > 0|1|1|SEARCH TABLE history AS h USING COVERING INDEX elid (elid=?) > > There is no more efficien

[sqlite] Query tooooo sloooooooooow

, 2015 at 11:03 AM, Clemens Ladisch wrote: > James Qian Wang wrote: > > select count(*) from contact c left join history h on (h.elid=c.elid); > > Please show the output of EXPLAIN QUERY PLAN for this query. > > If it does not look like this: > 0|0|0|SCAN TABLE contact A

[sqlite] Query tooooo sloooooooooow

ontact CREATE TABLE contact (name varchar(32), email varchar(128) unique , elid int(12)); CREATE INDEX elid2 on contact (elid); Table size: contact 20m history 10m elid integer and each elid has about 20k records Ideas please? Thanks a lot in advance -- James Qian Wang Mobile: 44 7986 099 233