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
That said, if I were you I would launch a beta, even if its only a private beta, just to get the word out there, that way you can preempt his launch by getting the word out there. See every feature that its not completely necessary to the minimal viable product, cut those and launch.
Bests of luck!