Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

2015-01-25 Thread Navin S Parakkal
On Saturday 24 January 2015 03:15 PM, Stefan Keller wrote: I think it's time for a serious simple benchmark with sqlite and say PostgreSQL. PostgeSQL also had performance problems time ago but this has been resolved. Can you describe the hp_table1 schema (CREATE TABLE statement...) and some

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

2015-01-25 Thread Navin S Parakkal
Hi, On Monday 26 January 2015 12:35 AM, Navin S Parakkal wrote: On Saturday 24 January 2015 03:15 PM, Stefan Keller wrote: I think it's time for a serious simple benchmark with sqlite and say PostgreSQL. PostgeSQL also had performance problems time ago but this has been resolved. Can you