my query take hundreds of MB temporary file if i execute this query. why sqlite make enourmous big temporary table. my table in only 9 MB and have 12000 row.
then i compare with mysql again, it's not make big temp table too much.
my query is in topic "[sqlite] confusing with how to to this in sqlite"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
