Hi all,

I'm just doing some basic database stuff. For arguments sake let's say a table has 200 items in it. I then have a list of 200 strings, and I need to find out if each one is in the array or not.

Is it quicker to do one query on the table to load an array, then loop through the array 200 times, or simply to do 200 queries?

I won't be doing anything with the table or the array afterwards, it's purely to check so I can decide which form to load, so it's not like any overhead is saved by having an array handy.

I've never really got the hang of what's the fastest way of doing things, so a little input is good.

Thanks for any input,
Si