"P Kishor" wrote... > 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. >
Yeah, I would say that he was funny. Thanks. I get it now. :-) josé >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users