|
-
May 14th, 2008, 11:29 PM
#3
Thread Starter
Hyperactive Member
Re: Optimization tricks needed - VERY LARGE Select Case statement
Hi there.
Your math is good, that roughly gives 10-12k words. Rest assured, I manually typed NONE of those words It originally came from some databases I found.
I wouldn't even need to do any sorting since I only need random results from it (I don't need to find one given word, nor a word beginning with "a" or based on length). Without remembering the exact syntax, it would be something like:
rstRandomWord.GoToRecord int(rnd*12000)
msgbox rstRandomWord!strRandomWord
But that's using a recordset. I'm not quite sure what you meant about "array MAPS", bout you brought up an interesting point: would it be better (in my case, based on speed when querying a word) to use a recordset or a simple array?
Anyone with an answer to that?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|