[sqlite] Performance Improvement

2011-07-18 Thread abhisek...@gmail.com
Hi, I am a new user of SQLite and I have a series of steps to do on a single table, and it takes way too long. I will outline the steps below and please let me know if I can do anything different to speed things up a bit. So I am coding up a cache simulator. The input basically consists of a seri

Re: [sqlite] Performance Improvement

2011-07-18 Thread abhisek...@gmail.com
this address was seen That is all. Please let me know if these can be optimized somehow. Thanks a lot for your help! Abhisek On Mon, Jul 18, 2011 at 10:58 AM, [email protected] wrote: > Hi, > > I am a new user of SQLite and I have a series of steps to do on a single > t

Re: [sqlite] Performance Improvement

2011-07-18 Thread abhisek...@gmail.com
issue. -Abhisek On Mon, Jul 18, 2011 at 11:01 AM, Stephan Beal wrote: > On Mon, Jul 18, 2011 at 4:58 PM, [email protected] > wrote: > > > These are addresses accessed by a program. There will be 100 billion > > entries > > > > You won't be able to fit that

Re: [sqlite] Performance Improvement

2011-07-18 Thread abhisek...@gmail.com
01:55PM +0200, Stephan Beal scratched on the > wall: > > On Mon, Jul 18, 2011 at 4:58 PM, [email protected] > > wrote: > > > > > These are addresses accessed by a program. There will be 100 billion > > > entries > > > > > > > You won't