IMHO, a benchmark like this is useless without any more information.
Some questions that i would like to see answered:
- Which SQLite and Postgres versions were used?
- Are the SQLite indexes, covering ones?
- Have any performance pragmas being used?
Also interval joins ("between") are hard for SQLite's default indexes,
but converting them to use a multidimensional index (R-Trees) speeds
them up to similar speeds as Postgres.
estama
On 2/3/2014 3:02 μμ, big stone wrote:
Hello,
This morning I saw Pandas/Wes McKinney communicating figures :
- starting at 37'37" of http://vimeo.com/79562736,
- leaking a slide where SQLite "is" 15 times slower than Postgresql.
==> the dataset is public :
http://www.fec.gov/disclosurep/PDownload.do?candId=P00000001&electionYr=2012&candNmTitle=All%20Candidates&downloadComeFrom=pNational
==> the sql are basic.
Wouldn't it be nice to update the "speed.html" page to have an objective
vision ?
Rationals :
- better show progress (it's hidden in
http://www.sqlite.org/checklists/3080300/index),
- better show non-time metrics : memory, electricity ,i/o...
- better show options effect : ":memory:" , "compile -o2", ...
- better show SQLite position in the SQL landscape.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
