I'm running queries against a 3rd party db through their odbc driver from access 2007. I'm noticing quite a difference in performance when using different pattern/wildcard matching techniques. Below are the details.
Using LIKE "W[DB]*" finishes in about 2 minutes.
Using LIKE "WD*" OR LIKE "WB*" finishes in about 5 seconds.
I like the first one because of simplicity and maintenance, but can't put up with the performance hit. Does anyone have any input on this? Is it Access or would it be the 3rd party ODBC driver? Is it possible to somehow improve the first scenario?
On Error Goto Hell
Msgbox("An error occurred, but was sent to Hell. You may continue.")