On 15 Jun 2011, at 7:48pm, David Lyon wrote: > chr19:200 > chr19:255492 > chr19:255667 > chr19:255879
Can you rejig the database so that leading zeros are always saved ? In other words, so that the data above becomes > chr19:000200 > chr19:255492 > chr19:255667 > chr19:255879 ? If so, you can do your SELECT and get the speed an index will give you. Without it, your SELECTs will execute slowly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
