Re: [sqlite] This great!

2006-07-17 Thread Martin Jenkins
Hi, The subscribe/unsubscribe info you want is in the message headers: List-Id: SQLite Users Mailing List List-Post: List-Help: List-Unsubscribe: List-Subscribe: Regards, Martin

Re: [sqlite] This great!

2006-07-17 Thread John Stanton
I think you have an interesting idea. Split the DB across disks so concurrent activities are on different spindles, preferably at 15,000 rpm and use a multiprocessor/core cpu with the application threaded so that you deploy more than one processor concurrently. If you could be sure to schedul

Re: [sqlite] This great!

2006-07-17 Thread Mohammad Shiful Islam
Hi, I want to unsubscribe. Please help on this. Regards, Arif __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] This great!

2006-07-17 Thread Cesar David Rodas Maldonado
Thanks Christian :D On 7/17/06, Christian Smith <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado uttered: > I am wondering if it will have a better performance if i split every index > and table into different files, i know that i will loose the LITE concept, > but i am wondering if it w

Re: [sqlite] This great!

2006-07-17 Thread Christian Smith
Cesar David Rodas Maldonado uttered: I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... Not unless each individual file is on a differ

Re: [sqlite] This great!

2006-07-17 Thread Cesar David Rodas Maldonado
I don't know I just was wondering... but i think it will be faster if you have a really great DB and when you and insert just will be locked the table where you are doing the insert not the whole DB... what do you think?

Re: [sqlite] This great!

2006-07-17 Thread Jay Sprenkle
On 7/17/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... I doubt it, unless

Re: [sqlite] This great!

2006-07-17 Thread Cesar David Rodas Maldonado
I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance...

Re: [sqlite] This great!

2006-07-17 Thread Eduardo
I am wondering if it will have a better performance if i split every index and table into a file, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... If you already played with pragmas you can try on windows 7-max (depends on your hardware) w

Re: [sqlite] This great!

2006-07-17 Thread Jay Sprenkle
On 7/17/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Hello to everybody...!!! I was using my old notebook the weekend, and i was doing some programs in C to try SQLite performance, and I am happy, because i could insert 4.000.000rows in 10 minutes in my old notebook( Pentium II 40

[sqlite] This great!

2006-07-17 Thread Cesar David Rodas Maldonado
Hello to everybody...!!! I was using my old notebook the weekend, and i was doing some programs in C to try SQLite performance, and I am happy, because i could insert 4.000.000rows in 10 minutes in my old notebook( Pentium II 400 MHZ 128 M.RAM). Thank for everybody who made it possible (share th