I don't know enough about MySQL but I know that the sqlite planner uses the data from analyze quite intensively. If you've just created a large dataset then you really need to let the planner know how effective and index search is via a table scan...
-- Peter Galbavy ------------------------------------------------------------------------ Peter Galbavy's Profile: http://forums.slimdevices.com/member.php?userid=32718 View this thread: http://forums.slimdevices.com/showthread.php?t=81733 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
