General information
Category:
Coding, syntax & commands
Just another thought on this...
You said you could have 10,000 commands or more. If you double that and assume that each command is at the maximum size of 999 characters, that yields a data file under 20MB in size. While respectable, that is not a huge size for a text data file...and this is a maximum case scenario.
What you might want to try is taking a version of your processing code and comment out the CASE statement that actually processes the commands. Then choose a sample file and compare the time it takes to run with just reading in the data and with doing the full processing. It might give you some information on where your overhead is, reading the data, processing the data, or half-and-half. (Be sure to do each test with a freshly copied data file, so you know you aren't reading from a cache.) Then you know where to target your efficiency efforts.
Anyway, it's just a suggestion.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only