I have a function that scans through alot of string data, is there a way I can improve memory efficiency ... so that if this function is called over and over ... perhaps in a loop, it will improve it's speed and won't tie up resources?
Printable View
I have a function that scans through alot of string data, is there a way I can improve memory efficiency ... so that if this function is called over and over ... perhaps in a loop, it will improve it's speed and won't tie up resources?
what kind of code do you have in it? EG loops, select statements etc
For the most part I have alot of Do ... Loop loops which are broken when an inStr returns a 0 or null.
What are the differences ... as far as efficiency between different methods of looping?
Mostly what I was thinking was that if you had a lot of code but only a few loops that maybe the code could be worked on. I don't really know any good ways to speed up loops. I've had progs that take time to go through loops as well but could never find a way around using them. Sorry I can't help :-( Good luck
OK thanks. :)