hey Jukka, just came across this mail. is this still an issue? can you provide me w/ a sample dataset?
..ede On 07.08.2017 09:46, edgar.sol...@web.de wrote: > 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 > _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
