Subscribe to this thread
Home - General / All posts - Viewer speed
artlembo


3,400 post(s)
#09-Dec-17 00:30

I just ran this query in both MF and viewer:

-- $manifold$

UPDATE(

 SELECT [pickup Drawing].mfd_id, o_zone, tzone FROM [pickup Drawing],

 (SELECT s_mfd_id, first(o_zone) as o_zone 

 FROM CALL GeomOverlayContainingPar([pickup Drawing] ([mfd_id][pu_geometry],tzone),

 [taxi_zones] ([zone] , [Geom]),

 0,ThreadConfig(SystemCpuCount()))

 GROUP BY s_mfd_id) AS computed 

 WHERE [pickup Drawing].mfd_id = computed.s_mfd_id

    )

SET tzone = o_zone

MF ran in under 8 minutes, while Viewer ran in over 10 minutes.

Is there any CPU limitation with Viewer? I thought it was just GPU.

adamw


10,447 post(s)
#09-Dec-17 07:59

There are no CPU limitations in Viewer. Is the difference consistent? Ie, if you tested Future first, Viewer second, switch the order + do two runs in each case instead of one to warm up and take the time for the second run. If it is, let us know and we will take a look (would appreciate example data).

artlembo


3,400 post(s)
#09-Dec-17 17:01

Ok, thanks. He taxi data is over 6GB, so I have to wait until Monday when I have higher bandwidth back at the office.

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.