I have added a new column with the date in seconds, created an index
over this column and modified the query a little bit. Now the query
takes less than 20 seconds. Since this is the worst case I'm happy with
the result.
Just for reference, the final query is:
SELECT STRFTIME('%Y-%m-%d %H
El 13/12/2011 17:44, Igor Tandetnik escribió:
On 12/13/2011 11:31 AM, Rafael Garcia Leiva wrote:
The problem is that is very slow. It takes nearly 24 hours to
query 1 year of Forex data in my laptop (and I have to work with 10
years periods). I will spend a couple of days learning about
ROUP BY CAST(STRFTIME('%s', e1.date) / (5 * 60) AS INTEGER)
On 2011-12-12 15:45:41 +0100, Rafael Garcia Leiva wrote:
El 24/11/2011 19:18, Rafael Garcia Leiva escribió:
Dear all,
I'm still working on this problem :-(
Now I need the Open and the Close of the 5 minutes interval, where
Open is the Open
El 12/12/2011 17:13, Igor Tandetnik escribió:
On 12/12/2011 9:45 AM, Rafael Garcia Leiva wrote:
Now I need the Open and the Close of the 5 minutes interval, where Open
is the Open of the first minute of the interval, and Close is the Close
of the last minute of the interval.
Something like
El 24/11/2011 19:18, Rafael Garcia Leiva escribió:
El 24/11/2011 14:49, 雷钦 escribió:
On 2011-11-24 08:02:21 +, Simon Slavin wrote:
On 24 Nov 2011, at 7:42am, Rafael Garcia Leiva wrote:
CREATE TABLE eurusd (
date TEXT NOT NULL PRIMARY KEY,
open REAL NOT NULL,
high REAL
El 24/11/2011 14:49, 雷钦 escribió:
On 2011-11-24 08:02:21 +, Simon Slavin wrote:
On 24 Nov 2011, at 7:42am, Rafael Garcia Leiva wrote:
CREATE TABLE eurusd (
date TEXT NOT NULL PRIMARY KEY,
open REAL NOT NULL,
high REAL NOT NULL,
lowREAL NOT NULL,
close REAL
6 matches
Mail list logo