[sqlite] SQLite index Idea for DBF

Hi All, I want to create index in “dbf” using SQLite index idea. I will give a little detail of my project. I am using SQLite for one of my project. I have dbf files with 30 million or 50 million records. And at the first stage I tried to covert the data in “db” and then apply different

[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.

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

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, PRAGMA

[sqlite] SQLite performance for 10 Million Records

Hello All, We are Using SQLite for one of our project. The Database Size is more than 500 MB. It contain one table and about 10 million Records. We are facing Problem in the select with single Join. The join is between a big table and a small table. The small table contain records not more

Re: [sqlite] SQLite performance for 10 Million Records

) // Now Please 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: We are Using

Re: [sqlite] SQLite performance for 10 Million Records

Elapse Time : 133 (Sec) // Where need chnge?. Regards TAMIMY On Mon, 19 Jun 2006 12:38:32 -0400, Derrell.Lipman wrote Manzoor Ilahi Tamimy [EMAIL PROTECTED] writes

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.

DEAR All , I want to use SQLite for our project, the main thing is that the database contains millions of Records. So for the faster operations on the db I want to use the SQLite as in-memory database. I have compared the results of SQLite as Disk db and as Memory db but I