First, a general question, then more specific:
General:
If I need to retrieve, manipulate and store data, which method is faster?Specific:
- 10 x 10 array of string data
- worksheet, 10 rows x 10 columns
Currently, I import web data into a worksheet, with about 10 to 20 rows imported per website import. The complete set of imports results in approximately 25,000 rows x 8 columns: 7 columns are strings (< 75 chars each), one column is a hyperlink to another web site.
Granted, the web retrievals are the long pole in the tent, what would be faster?Thank you in advance for your insights.
- Import data into a 25,000 x 8 array, concatenate some strings, conditional changes to cells, write entire "cleaned up" array to a worksheet
- Import all data into a 25,000 x 8 worksheet range, unmerge 3 columns, concatenate strings, conditional changes to cells, delete "extra" rows as processed
- For each import, store data in a 4 x 8 array, perform manpulations, write resulting 1 row record to worksheet
Bookmarks