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! 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é _______________________________________________ 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