News for hackers. Stuff that matters.
Re:An Obscure Competitor is Giving Away My Product by kellyreid on Tuesday December 06, 2011 @01:17AM (#3318230)
I have a few biz owners who are actually waiting for a beta invite already. I just put a nice UI on top of it last night so it looks like a 'product', and I'll be giving them the keys to test drive as soon as I rewrite my queries so it doesn't take 5+sec to render a graph and 20+ sec to pull historical pricing data.

Query run times, above all, is where my inexperience shows the most and is by far the most hamstringing part of this process.

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