Now I'm can you be 50% faster if 90% of the time is in 
retrieving from Oracle?
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems


From: on behalf of Werner Smit
Sent: Wed 7/14/2010 11:11 AM
To: General Discussion of SQLite Database
Subject: EXTERNAL:Re: [sqlite] Sqlite Insert Speed Optimization

>>According to my math your final database size should be on the order
>>That means at 200 minutes and 1,000,000 records:
>>83 inserts per second
>>8333 bytes per second

>>Both of these values are terrible.

>>#1 What kind of network connection do you have?  100BaseT?
>>#2 What kind of server are you writing to?
>>#3 How fast does this run if you write to your local machine?

>>Michael D. Black

>It DOES sound terrible since 90%? of the time is spend in retrieving
>data from a remote oracle server over a slow line. The problem is that
>the time spend saving to sqlite is still more than I used to spend on
>saving to my previous file system.

>Can you answer #3 though?

It's nearly 50% faster.

>Does anybody know how to make the journal file go to a different
location than the database?  Apprarently it's not treated as a
"temporary" file.  Perhaps it should be??

Everything in this email and its attachments relating to the official business 
of Face Technologies is proprietary to Face Technologies. It is confidential, 
legally privileged and protected by law. The person addressed in the email is 
the sole authorised recipient. Any unauthorized dissemination or copying of 
this e-mail (or any attachment to this e-mail) or the wrongful disclosure of 
the information herein contained is prohibited.

sqlite-users mailing list

sqlite-users mailing list

Reply via email to