rs@sqlite.org
To:
Subject: Re: [sqlite] SQLite Order BY Date: Mon, 9 Oct 2006 11:59:46
+0800
//--
Dar All,
Can someone guide me, why the ORDER BY in SQLite is too slow. w
Thanks shiming
we have tried this method as u suggested , but creating an index on a 5
million records
take a long time, nearly 4 seconds.
And in our case the Database contain 5 Million to 30 or 50 million
records. so if I try to create additional indices on these tables it takes
too much tim
hvh5m.Column8. They should speed things up.
Best regards,
He Shiming
From: "He Shiming" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To:
Subject: Re: [sqlite] SQLite Order BY Date: Mon, 9 Oct 200
Dar All,
Can someone guide me, why the ORDER BY in SQLite is too slow. we observed
that if the change in data values is small then ORDER BY works better .
but if the change is big then the performance is very slow. Even sometime
I can not finish a query execution, and wait and may be sometim
Dar All,
Can someone guide me, why the ORDER BY in SQLite is too slow. we observed
that if the change in data values is small then ORDER BY works better .
but if the change is big then the performance is very slow. Even sometime I
can not finish a query execution, and wait and may be someti
5 matches
Mail list logo