Functions and memory

[MicahCarrick]

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?

[netSurfer]

what kind of code do you have in it? EG loops, select statements etc

[MicahCarrick]

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?

[netSurfer]

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

[MicahCarrick]

OK thanks.