Hi, There seems to be some inefficiency in parsing date field from Spatialite database by using the Run database query tool. Reading 8 million points with one DATE field takes 15 minutes with my computer. If I do not select the DATE field it takes only 35 seconds to get all the data.
DB Query plugin cannot parse DATE fields at all so I could not make a proper comparison. Query without DATE field took 3 times more time with DB Query. -Jukka Rahkonen- ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel