On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon <n...@gammon.com.au> wrote:
> > 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. > > it has something to do with type affinity. I don't think you would have had this slow down if your type was TEXT, because (I think) sqlite would have not tried to convert it. Anyway seems to be improved now. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
