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

Reply via email to