After recent postings, I have a demo version of SQLite manager. I'm noticing that the same simple query (SELECT * FROM <table>) on a table with around 50k rows takes anywhere from 3-10 times longer in the SQL tab than the Manage tab according to the timings that SQLite Manager shows. Any ideas why that might be? The longer times are still very fast but I'm curious to know if there are some ways of retrieving data that are faster than others for the same query.
Thanks -- Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users