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 op
,
Manzoor Ilahi Tamimy
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
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
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
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
)
//
Where need chnge?.
Regards
TAMIMY
On Mon, 19 Jun 2006 12:38:32 -0400, Derrell.Lipman wrote
> "Manzoor Ilahi Tamimy" <[EMAIL PR
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:
> >
> >>
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 t
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...
---
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 a
11 matches
Mail list logo