probably exactly the same issue of realtime date parsing during loading like w/ JML there. maybe i can speed up the parser, by meorizing the successful pattern and trying that first on the next value. currently it looks like it is bruteforcing the same pattern order over & over agn.
..ede On 8/6/2017 21:51, Rahkonen Jukka (MML) wrote: > 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 > ------------------------------------------------------------------------------ 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