Re: [sqlite] SQLite index Idea for DBF

2006-08-25 Thread Kees Nuyt
On Fri, 25 Aug 2006 13:58:09 +0600, you wrote:

> 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 operations. 
>
> But because of the slow performance in case of converting
> data into dbf to db I changed the design and now I did
> some modifications and I am directly reading the data
> from dbf files.  
>
> So now I want to create index in “dbf” using SQLite index Idea. 
>
> Can anyone guide me how to start.

What type of database is "dbf" ?
What type of database is "db" ?

If "dbf" is dBase, FoxBase or something like that it doesn't
make much sense to have data in that database indexed by SQLite.
You'd better use the index of that given database, or speed up
the conversion process.
 
>Regards,
>
>Manzoor Ilahi
-- 
  (  Kees Nuyt
  )
c[_]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] SQLite index Idea for DBF

2006-08-25 Thread Manzoor Ilahi Tamimy


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

But because of the slow performance in case of converting data into dbf to db 
I changed the design and now I did some modifications and I am directly 
reading the data from dbf files.  

So now I want to create index in “dbf” using SQLite index Idea. 

Can anyone guide me how to start.
 
Regards,

Manzoor Ilahi

-
To unsubscribe, send email to [EMAIL PROTECTED]
-