While running quite a few readWhere queries, I noticed the function
call_on_recarr takes a significant more amount of time than any other function.
Any idea on what I'm doing wrong. Is there a way to speed it up?
Thanks,
Vineet
ncalls tottime percall cumtime percall filename:lineno(function)
24895 37.098 0.001 37.418 0.002
/usr/lib/python2.5/site-packages/tables/conditions.py:163(call_on_recarr)
499 0.038 0.000 7.704 0.015
/usr/lib/python2.5/site-packages/tables/table.py:1199(_where)
273 0.654 0.002 7.484 0.027
/usr/lib/python2.5/site-packages/tables/table.py:1244(readWhere)
273 0.027 0.000 5.812 0.021
/usr/lib/python2.5/site-packages/tables/_table_pro.py:148(_table__whereIndexed)
534 2.046 0.004 4.755 0.009
/usr/lib/python2.5/site-packages/tables/index.py:1932(get_chunkmap)
499 0.022 0.000 1.773 0.004
/usr/lib/python2.5/site-packages/tables/table.py:1045(_compileCondition)
499 0.008 0.000 1.708 0.003
/usr/lib/python2.5/site-packages/tables/conditions.py:107(compile_condition)
500 0.011 0.000 1.453 0.003
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:495(numexpr)
500 0.022 0.000 1.413 0.003
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:432(precompile)
226 0.001 0.000 1.019 0.005
/usr/lib/python2.5/site-packages/tables/table.py:1126(where)
192624/28692 0.526 0.000 0.941 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:47(__hash__)
546 0.730 0.001 0.861 0.002
/usr/lib/python2.5/site-packages/tables/index.py:1757(search)
500 0.037 0.000 0.828 0.002
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:306(optimizeTemporariesAllocation)
28154/28020 0.188 0.000 0.385 0.000
/usr/lib/python2.5/site-packages/tables/file.py:876(_getNode)
500 0.006 0.000 0.209 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:284(collapseDuplicateSubtrees)
26978 0.153 0.000 0.164 0.000
/usr/lib/python2.5/site-packages/tables/file.py:260(__getitem__)
9672/1592 0.061 0.000 0.163 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:108(typeCompileAst)
273888/68964 0.157 0.000 0.157 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:66(postorderWalk)
19243 0.026 0.000 0.143 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:72(allOf)
501 0.011 0.000 0.120 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:191(stringToExpression)
499 0.002 0.000 0.111 0.000
/usr/lib/python2.5/site-packages/tables/_conditions_pro.py:209(_get_idx_expr)
2401/499 0.015 0.000 0.109 0.000
/usr/lib/python2.5/site-packages/tables/_conditions_pro.py:101(_get_idx_expr_recurse)
273 0.002 0.000 0.107 0.000
/usr/lib/python2.5/site-packages/tables/table.py:1606(readCoordinates)
273 0.008 0.000 0.098 0.000
/usr/lib/python2.5/site-packages/tables/table.py:1573(_readCoordinates)
4849 0.009 0.000 0.089 0.000
/usr/lib/python2.5/site-packages/tables/_conditions_pro.py:24(newfunc)
3 0.000 0.000 0.071 0.024
/usr/lib/python2.5/site-packages/tables/array.py:486(__getitem__)
3 0.000 0.000 0.071 0.024
/usr/lib/python2.5/site-packages/tables/array.py:565(_readSlice)
1000 0.007 0.000 0.067 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/compiler.py:266(assignLeafRegisters)
2949 0.016 0.000 0.067 0.000
/usr/lib/python2.5/site-packages/tables/numexpr/expressions.py:45(func)
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Pytables-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pytables-users
