in reply to Re: How best to optimize shared data
in thread How best to optimize shared data
good reply; listen to the man.
normalized tables and indexes are key!
properly implemented indexes took a script of mine from a 8 minute run-time to a 1-2 minute runtime. Long story short, they can help a lot!
Justin