The easiest solution is breaking it up into multiple tables. You're going through WAY too much useless data per search. if you were to make 4 tables at 1/4 the size, you're only looking at about 33 million operations. That should run more then ten times as fast. (16 times as fast in theory, but the other tables will generate some overhead.) That should keep any lookup under .5 seconds.
Your best bet is optimizing everything as best you can. Making it so it looks "per channel" as opposed to "global" would vastly improve the script. Yes, this will generate some extra baggage, but it will go much quicker.
Last edited by Thrull; 17/06/08 09:14 AM.
