Re:An Obscure Competitor is Giving Away My Product
by kls on Tuesday December 06, 2011 @02:13AM
(#3318396)
Are you running a relational database? if so check all of your indexing. Unless you are doing some pretty crazy stuff indexing should reduce those queries to milliseconds.
Re:An Obscure Competitor is Giving Away My Product
by kellyreid on Wednesday December 07, 2011 @07:19PM
(#3326893)
Yes, mySQL. I'm sure I've made loads of mistakes in structuring things. I don't know where to start checking my indexes for mistakes though. Any resources you can point me at that are somewhat newbie friendly?
Re:An Obscure Competitor is Giving Away My Product
by kls on Wednesday December 07, 2011 @08:19PM
(#3327073)
First thing to do is look at you where and order/group by clauses almost all of the items listed after them should have an index on them. Many should have a common index on the columns together, if they are used together a lot to filter information.
Re:An Obscure Competitor is Giving Away My Product
by kellyreid on Wednesday December 07, 2011 @11:17PM
(#3327635)
hmm. that makes a lot of sense. can you suggest some reading that can help me understand which types to use? I'm almost entirely self-taught on SQL so the result is "functional" code that's just not well-designed or optimal
Query run times, above all, is where my inexperience shows the most and is by far the most hamstringing part of this process.