Thomas Flemming Tue, 30 May 2017 09:43:15 -0700
>> Try putting a "+" symbol before "styleid". Like this: >> >> AND +styleid IN (1351,1362,1371,1374,1376,1542,1595,1597,1643,1762) > THATS IT !!!!!!!!!! :-))) > > 50ms with +, and 15000ms without the + > > How is that possible? Hello, best explained here: http://sqlite.org/optoverview.html#uplus (a most interesting document anyway) Regards, E. Pasma _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users