On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote: > Is it normal that fromuid of the table exits is STRING ? > I think it should be TEXT to be surely processed as text and not float
That was an error. However it shouldn't take SQLite 2.5 seconds to handle *any* numeric literal. Especially as it was quoted. For example, in C you don't expect: x = "123E45678942"; ... to go through any sort of numeric conversion. Now I know this isn't C, but the "let's see if we can turn a string into a number, and take two to three seconds to do so" is not right, IMHO. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users