On Sun, Feb 22, 2009 at 2:14 PM, Fred Williams <f.willi...@verizon.net> wrote: > Since the dawn of digital computers the CPU has been waiting on the I/O. > Want to go faster? Get a faster mass storage device. Then your CPU usage > will most likely jump all the way up to 9% - 14%! > > You can't believe what a 300 card per minute 80 column card reader does to > throughput when you use it to replace a 100 card per minute reader! I know, > been there, done that! :-) > > Sit back and watch the flashing lights. BUT, keep your hands in your > pockets!
Very funny and illuminating as well. Here is another way to look at it. Moving at the speed of light, that is, at 186,000 miles per second, electrons take about 0.00000000101824698598782 seconds to travel about 12 inches, say, the distance between the data on the hard disk platter and the CPU. Pretty damn fast, I say. Except, in that time, my lowly Macbook CPU flipping around wildly at 2.4 GHz, has already been waiting, twiddling its thumbs for almost 2.5 cycles. Work on improving your db, your application and your hard disk. Or buy enough ram to put everything in etherspace, then go get a cup of coffee. > > Fred > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of jose isaias cabrera > Sent: Sunday, February 22, 2009 1:57 PM > To: General Discussion of SQLite Database > Subject: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite > > > > Greetings! > > I have a very small database, well, 62.1 MB (65,150,976 bytes), and when I > do a search on it, the CPU only goes to 7% and 12% at the most. Sometimes > it takes a few seconds to return with the results. I am not complaining > about the 5-10 seconds of the returning of the result, but I believe that if > the CPU would be used more, the result would return in 1-4 seconds. > > I have left everything default, so I have not set any PRAGMA settings. > > Any ideas on how to make SQLite use the CPU more since it is sitting there > with System Idle Process 93%. > > Any help would be greatly appreciated. > > thanks, > > josé > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
