AnsweredAssumed Answered

Dynamic Search Script

Question asked by SCOPe on Feb 24, 2010
Latest reply on Feb 24, 2010 by SCOPe

Title

Dynamic Search Script

Post

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?

Outcomes