SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 8 of 8
  1. #1
    Junior Member
    Join Date
    Aug 2003
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Large HTML tables

    Hi,

    I am reading all the data out of a large html table and at times it takes 10-15mins to complete.

    I use web_obj_get_text(Table,Row,Column,Value);
    looping through each cell

    Is there a faster way to do this? or is this the fastest WR will go.
    Frankie

  2. #2
    Moderator JakeBrake's Avatar
    Join Date
    Dec 2000
    Location
    St. Louis - Year 2025
    Posts
    15,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    Try running the script in a minimized state and let us know if you experience any performance gains.

  3. #3
    Junior Member
    Join Date
    Aug 2003
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    Ran a test case in with out minimizing and it ran in 5 mins 57 secs. With minimized it ran in 5 mins 50 secs.

    So slightly quicker - Cheers.

    Any other ideas?
    Frankie

  4. #4
    Moderator JakeBrake's Avatar
    Join Date
    Dec 2000
    Location
    St. Louis - Year 2025
    Posts
    15,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    Considerations:

    1) Are you running the test scripts locally or off a server? Best to run locally.
    2) PC CPU speed.
    3) RAM
    4) Size of app under test
    5) SWAP
    6) GUI map size - if large number of objects, break into multiple files. Large varies with RAM. I would suuggest if your WRun host has 256 or less and you have more then 500 objects in one map file, break it up.
    7) Make sure there are no embedded wait statements.
    8) Check your WRun options settings - run as fast as possible.
    9) Does a 3d screen saver come on during the replay? If so - disable it.

  5. #5
    Senior Member
    Join Date
    May 2001
    Location
    Ankh-Morpork
    Posts
    2,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    Write a Perl script to exctract the desired data from the HTML source? [img]images/icons/wink.gif[/img] (This is only half facetious.)
    web site | [url=http://www.ebookworm.us/[/url]

    [i]...Sound trumpets! Every trumpet in the host! / Sixty thousand, on these words, sound, so high the mountains sound, and the valleys resound.</i] (The Song of Roland)

  6. #6
    Junior Member
    Join Date
    Aug 2003
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    1. Running everything locally.
    2. CPU Speed - 2.53 GHz
    3. 522,224 KB RAM
    4. Application is a large html table and I have to take all the values out of the table and insert into a MS Access DB.
    5. Whats do you mean by SWAP???
    6. 57 items in the GUI map.
    7. I have no wiat statements only websync's.
    8. Have it at run as fast a possible.
    9. Haven got a 3d screen saver but I using let them run in batch over night and I turn off the monitor. Would this make a difference???

    Also would making variable names and reducing the amount of white space make much of a difference???

    Thanks for all your help.
    Frankie

  7. #7
    Junior Member
    Join Date
    Aug 2003
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    so I meant to say making the variable names smaller...
    Frankie

  8. #8
    Senior Member
    Join Date
    May 2001
    Location
    Ankh-Morpork
    Posts
    2,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Large HTML tables

    White space, variable name lenght, comments, etc. have a very small impact, at least in my experience.

    SWAP space is the same as virtual memory.

    Question: is ~6 minutes significantly faster than the time it would take to do manually? If so, is it really that much of a problem (particularly if it is more accurate than doing it by hand)?
    web site | [url=http://www.ebookworm.us/[/url]

    [i]...Sound trumpets! Every trumpet in the host! / Sixty thousand, on these words, sound, so high the mountains sound, and the valleys resound.</i] (The Song of Roland)

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:22 PM.

Copyright BetaSoft Inc.