As the topic goes I am new to Sqlite. The gui I'd been using was compiled with an older version, than the 3.6.10 cli I downloaded. So things were a bit choppy. I'll stick to using just the downloaded Sqlite cli, now I (sort of) know what I'm doing with it.
I'll post the results once I've finished trying all the options, it's looking good so far though :-) k D. Richard Hipp wrote: > > On Feb 23, 2009, at 2:42 AM, Kim Boulton wrote: >> >> But OR is a lot slower than using UNION ALL on both Sqlite and Mysql > > > The optimizer was significantly enhanced for version 3.6.8 in order to > better handle OR in WHERE clauses. What version of SQLite did you > test this with? > > > D. Richard Hipp > [email protected] > > > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
