Thank you immensely to John LeSueur, Dr. Hipp, Derrell Lipman and Frank Baumgart. I incorporated much of your suggestions and the query times from the sqlite command prompt are down to milliseconds and from a simple C program, down to 10 seconds ( I used this code: http://www.hwaci.com/sw/sqlite/quickstart.html) Is sqlite_compile much faster?
Thanks again. Regards
