Re: [sqlite] SQLite Order BY

2006-10-09 Thread John Stanton
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

Re: [sqlite] SQLite Order BY

2006-10-09 Thread He Shiming
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

Re: [sqlite] SQLite Order BY

2006-10-09 Thread Manzoor Ilahi
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

Re: [sqlite] SQLite Order BY

2006-10-08 Thread He Shiming
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

[sqlite] SQLite Order BY

2006-10-08 Thread Manzoor Ilahi
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