Re: [sqlite] SQLite Order BY

time. any other suggestions if u have please. Best regards, Manzoor Ilahi //-- You can try creating two additional indexes, one on hvh5m.Column4 and the other on

[sqlite] SQLite Order BY

sometime need to kill the process. also another point that i observed is , when ..order by fieldName , if fieldName is varchar,the excutiion is faster ,and if fieldName is float,the execution can't be finished! Any Idea Please thanks Manzoor Ilahi Queries that we tested and the Sche

[sqlite] SQLite index Idea for DBF

. Regards, Manzoor Ilahi - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] SQLite with Index

, Manzoor Ilahi Tamimy - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Attach db code

Hi All, Can someone give me the code you use to attach a database. I have a db file with 5 Million records and have three different tables. Index is also created in it. I want to load it in memory to apply some queries for testing. Best regards, Manzoor Ilahi Tamimy

[sqlite] Query Execution speed.

ay 2006 " performance v2 and V3 " I found that Version 2.8 was much Faster than 3.6 using ":memory:", 30 Seconds and 60 seconds in case of 2.8 and 3.6 respectively. can I use 2.8 in my project when i have a huge amount of data to handle. Thanks Regards, Manzoor Ilahi Tamimy

Re: [sqlite] SQLite performance for 10 Million Records

Hi, I am really really thankful to all the members of this group. The Discussion here was really very helpful for me and also for the others. I was not as much experienced as the other members who took part in this dicussion, but i worked hard ad spent a lot of time to find out why i am getti

Re: [sqlite] SQLite performance for 10 Million Records

I have tested my Code with the following PRAGMA and still not getting any change in time. //-- sqlite3_exec(db, "PRAGMA temp_store=2", NULL, NULL, NULL); sqlite3_exec(db, "PRAGMA synchronous=0", NULL, NULL, NULL); sqlite3_exec(db, "PRAG

Re: [sqlite] SQLite performance for 10 Million Records

) // Where need chnge?. Regards TAMIMY On Mon, 19 Jun 2006 12:38:32 -0400, Derrell.Lipman wrote > "Manzoor Ilahi Tamimy" <[EMAIL PR

Re: [sqlite] SQLite performance for 10 Million Records

ase have look at these results. What should I do now to improve the performance. Thanks and regards Manzoor Ilahi Tamimy On Mon, 19 Jun 2006 09:47:03 -0400, Derrell.Lipman wrote > Bill King <[EMAIL PROTECTED]> writes: > > > Manzoor Ilahi Tamimy wrote: > > > >>

[sqlite] SQLite performance for 10 Million Records

using SQLite in memory mode. Thanks. Manzoor ILahi

RE: [sqlite] Pragmas

Dear Anish I am using the same --- sqlite3_open(database, &db); sqlite3_exec(db, "PRAGMA page_size=4096", NULL, NULL, NULL); sqlite3_exec(db, "create table t... ---

[sqlite] HELP for SQLite MEMORY test.

m missing something or some necessary parameters. I spent a lot of time to find out the problem. Please Guide me. I will be really thankful. Regards, MANZOOR ILAHI -- COMSATS Institute of Information Technology (http://www.ciit.edu.pk)