Dynamic Search Script
So I'm working on a "dynamic" search script. Basically it searches as you type, and it works really well! I've been working off a few samples that other people have created. My question is though. Why is searching on a field, in a different table, but the same database so much slower? The only way I've been able to increase performance is to create a duplicate field in the table I'm searching from, and make it a lookup to the original field on creation. Is there any other way to increase the performance?