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