coolair
V2EX  ›  问与答

有人知道 Python 的这种时间测试是用的什么工具么?

  •  
  •   coolair · Jun 8, 2016 · 1147 views
    This topic created in 3632 days ago, the information mentioned may be changed or developed.
    Here are all the details:
    My excel file:
    9 sheets, 111 columns 8788 rows each.
    Actually most of the cells are blank (let's say whe have about 3000
    cells filled)
    Anyway the workbook will be progressively filled, up to 2millions
    cells filled.

    I am running my script on windows Vista Home and on Sun Solaris 5.9

    times (Vista Home)
    xlutils.copy() (on_demand = True) : 42.940000 seconds
    xlutils.copy() (on_demand = False) : 39.146000 seconds

    times (Solaris 5.9)
    xlutils.copy() (on_demand = True) : 02 mins 42.486900 seconds
    xlutils.copy() (on_demand = False) : 02 mins 29.924702 seconds


    versions (both vista and solaris):
    Python 2.5.4
    xlutils 1.3.2
    xlrd: 0.7.1
    xlwt 0.7.2

    cheers
    Mauro
    1 replies    2016-06-08 19:37:00 +08:00
    mengzhuo
        1
    mengzhuo  
       Jun 8, 2016 via iPhone
    import time
    start = time.time()
    // .....
    print time.time() - start
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3918 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 48ms · UTC 00:55 · PVG 08:55 · LAX 17:55 · JFK 20:55
    ♥ Do have faith in what you're doing.